Hello.
First read:
http://dev.mysql.com/doc/mysql/en/charset.html
mysqldump could put SET NAMES 'utf8' at the beginning of the dump
file, check it and remove or perform a dump using --set-names=gbk.
Use --defaults-character-set=gbk for mysql client (or put correct
values for character_set_xxx variables in configuration file).
Use
show variables like '%char%';
to debug this issue.
What's more, I can't find gbk.xml and gb2312.xml at
/usr/share/mysql/charsets, need I download them from somewhere?
Probably it is a compiled in character set. See README file in charsets
directory.
Chenzhou Cui [EMAIL PROTECTED] wrote:
Dear all,
I am a Chinese and using Chinese in my MySQL databases.
On my old server, the version of MySQL is 3.23.58. And my new MySQL is
4.1.7.
On my old server, the MySQL works well with my Chinese contents.
However, after I transfer tables to the new server using:
mysqldump --opt database | mysql -h 'newserver' database
The new server can't display Chinese contents correctly. What need I do?
What's more, I can't find gbk.xml and gb2312.xml at
/usr/share/mysql/charsets, need I download them from somewhere?
Thanks a lot,
CB
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]