chinese character can't show properly?
hi ,every one,appreciated any help from you !
i stoped mysql server with os windows server 20003 and copyed the total data from
one server to another server with same os a few days before.
it works well when i start the services.
But ,when i run the command ,it can't show it rightly and show me ?????instead when the result with chines character set . i am a newbie,so i guess it may be something wrong with the charset settings .However,when i change the charset to gbk,big5,utf8,...,mysql return the same result.At the same time ,i also reconfig the my.ini,but i failed too.
when i have no choice ,i dump one of my table to get table.sql and
table.txt ,command like this:
mysqldump -T=dir -u -p -d table,
and then i load data into another computer with the ubuntu os.
mysql -u -p <table.sql
load data local infile 'data' into table
the chinese character show rightly .
addtion,execpt the os system charset is different(one is dos window ,one is shell window) ,the other settings like
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1
| character_set_server | latin1
when i run the command show variables like '%char%' .
So ,my question is how can I sovle this problem in windows platform ?
if so,what should i do?
|
Edited 1 time(s). Last edit at 03/01/2010 07:06PM by liou zhaoxing.