MYSQL creates a database in UTF-8 format first mysql enters: www.2cto.com Linux code GBK: create DATABASE test2 default character set gbk COLLATE gbk_chinese_ci; UTF8: CREATE database 'test2' default character set utf8 COLLATE utf8_general_ci; eg: Linux code www.2cto.com [root @ linuxtest test] # mysql-u root-p Enter password: Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 5 Server version: 5.1.30-community MySQL Community Server (GPL) Type 'help; 'or' \ H' for help. type '\ C' to clear the buffer. mysql> create database 'test' default character set utf8 COLLATE utf8_general_ci; Query OK, 1 row affected (0.06 sec) mysql> show databases; + -------------------- + | Database | + -------------------- + | information_schema | cacti | mysql | test | + ------------------ + 5 rows in set (0.07 sec) The test Library is in UTF-8 format