Summary of viewing and modifying mysql encoding and data table Encoding

1. Check the encoding of your installed mysql.

2. Check the encoding supported by Mysql.

3. view the database code

4. view the data table encoding (show create table user \ G ;)

5. Modify the my. ini file to modify the encoding: add the default-character-set = character set (utf8.gbk. gb2312, etc)

6. Modify the command line: alter database da_name default character set "charset"; or set names 'charset'; or alter database testdb character set utf8;

8. view the character set of the Database Service and client:

9. Modifications in Linux: <喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> VcD4KPHA + records/bK/records + CjxwPjIpsum/tLW8s/records + NCnBrL3Tyv2 + 3b/isqKy6b + 0 tbHHsL/records + records = "gbk';

6) view the current Encoding
Mysql> status;
Server characterset: latin1
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk

7) import the file converted to gbk
Mysql> source base_user_gbk. SQL;