only a part of string is inserted
Posted by: Laima Vakrinaite
Date: May 17, 2005 06:36AM


can anyone help me, please

i wrote a procedure that uses cursor to fetch string into a variable. Then i want to insert this variable into another table.

but my procedure inserts only a part of a string. it prints all the letters in the string until the first special character. if there aren't any special characters - it inserts all the line rightly.

for example:

Table 1 -> Table 2
Didžiosios -> Did
Anykščių -> Anyk
Žiežmarių ->
Dvejetainis kodas -> Dvejetainis kodas

data type and size of a variable and of fields in both tables are the same.
charset of the table is utf8, collation - utf8_unicode_ci

OS windows xp, mysql server 5 beta

Edited 1 time(s). Last edit at 05/17/2005 06:37AM by Laima Vakrinaite.

Options: ReplyQuote

Written By
only a part of string is inserted
May 17, 2005 06:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.