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]