Problem about displaying chinese characters
Posted by:
milo_11
Date: October 05, 2005 08:07AM
I am using MySQL ver.1.4.14 in WindowXP as a service. I create a table using a utf8 character set. I have no problem to display the chinese characters when I input the data in the command line interface. However, when I try to load my plain text file into the table. All the chinese characters become '????' Why this happens?
Secondly, although I can input and output the chinese characters correctly, some of the chinese characters are still in '????' such as this character 許. How to solve this problem?
By the way, after I set the character set to ucs2, no matter I enter any SQL commands, it always displays a sytax error message. This seems very strange...
Subject
Views
Written By
Posted
Problem about displaying chinese characters
3307
October 05, 2005 08:07AM
1950
October 10, 2005 06:21PM
1876
October 10, 2005 09:14PM
1913
October 11, 2005 06:51AM
1939
October 11, 2005 06:52AM
1977
October 16, 2005 07:01PM
2034
October 17, 2005 07:53AM
2049
October 18, 2005 07:38AM
1951
October 21, 2005 07:20AM
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.