469,572 Members | 1,343 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

Importing chinese characters

I've got a problem with importing chinese characters into a mysql-table
and have read several mailings but didn't find a solution.

i have a utf-8 text file that contains chinese characters. the table
where i want to import the data using "load data local infile" has
collation utf8_unicode_ci. but after the import is done, the chinese
characters are converted into so strange characters. to show the
chinese symbols in a php-script i use mb_convert_encoding() which shows
me the characters properly, but the problem is that i have to order by
the col that contains the chinese characters, so the chinese characters
mustn't be converted after importing. when i use the form in phpmyadmin
to add data it is possible to store the characters properly. is there a
way to achieve this by using load data local infile?

Jul 10 '06 #1
0 3373

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jeff | last post: by
8 posts views Thread by Agnes | last post: by
8 posts views Thread by pabv | last post: by
19 posts views Thread by many_years_after | last post: by
5 posts views Thread by Figmo | last post: by
2 posts views Thread by Wassy | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.