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 <ccz@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
