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
3553
October 05, 2005 08:07AM
2057
October 10, 2005 06:21PM
1981
October 10, 2005 09:14PM
2013
October 11, 2005 06:51AM
2035
October 11, 2005 06:52AM
2080
October 16, 2005 07:01PM
2127
October 17, 2005 07:53AM
2162
October 18, 2005 07:38AM
2053
October 21, 2005 07:20AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.