Question Migration problem with japanese characters

And did you also remember to put SQL into UTF-8 mode before you make any queries? You can change DB to send rows in custom charset, even if the tables are encoded in different encoding.

Hi,

Yes, I already changed the charset to unicode, this issue is fixed, the problem is in the php script. However the japanese texts are not a lot, I'm coping manually the original japanese text directly into the db.

Unfortunately there are too much japanese texts as expected, it will be a very hard work to copy and paste all the japanese string in the correct position and the probability to make some mistake is very hight. I must to find a way to have the importing script working also with unicode characters..... suggestion?

Again: In converter you need to tell MySQL to talk UTF-8 to you. Changing the tables is not enough as MySQL happily converts (by default) your strings to ISO-8859-1 when it is sending them to the client.

Hi Matias,

I'm sorry but I'm not a php programmer than I don't understand the modify I must to do into the script. Is there some special "command" I must to add at the beginning of the php code?
Thank you for the help

Something like this:

mysql_query( "SET NAMES 'utf8'", $database );