mysql> status

--------------mysqlVer14.14Distrib5.6.44,forLinux(x86_64)usingEditLinewrapperConnectionid:22Currentdatabase:Currentuser:root@localhostSSL:NotinuseCurrentpager:stdoutUsingoutfile:''Usingdelimiter:;Serverversion:5.6.44MySQLCommunityServer(GPL)Protocolversion:10Connection:LocalhostviaUNIXsocketServercharacterset:latin1Dbcharacterset:latin1Clientcharacterset:utf8Conn.characterset:utf8UNIXsocket:/var/run/mysqld/mysqld.sockUptime:6hours31min31secThreads:1Questions:905Slowqueries:1Opens:74Flushtables:1Opentables:67Queriespersecondavg:0.038--------------

Server characterset:latin1
Db characterset:latin1 (数据库编码格式)
Client characterset:utf8(客户端连接进来的编码格式)
Conn. characterset:utf8(接入的编码格式)

show variables like 'character'

mysql>showvariableslike'character%';+--------------------------+----------------------------+|Variable_name|Value|+--------------------------+----------------------------+|character_set_client|utf8||character_set_connection|utf8||character_set_database|latin1||character_set_filesystem|binary||character_set_results|utf8||character_set_server|latin1||character_set_system|utf8||character_sets_dir|/usr/share/mysql/charsets/|+--------------------------+----------------------------+

/etc/my.cnf文件中修改配置信息

使用默认的配置信息

本机访问自己的数据库:Server characterset:latin1

status

Servercharacterset:latin1Dbcharacterset:latin1Clientcharacterset:utf8Conn.characterset:utf8

show variables like 'character%'

+--------------------------+----------------------------+|Variable_name|Value|+--------------------------+----------------------------+|character_set_client|utf8||character_set_connection|utf8||character_set_database|latin1||character_set_filesystem|binary||character_set_results|utf8||character_set_server|latin1||character_set_system|utf8||character_sets_dir|/usr/share/mysql/charsets/|+--------------------------+----------------------------+

创建一个数据库encodtest,查看其编码信息

Servercharacterset:latin1Dbcharacterset:latin1Clientcharacterset:utf8Conn.characterset:utf8

mysql>showvariableslike'character%';+--------------------------+----------------------------+|Variable_name|Value|+--------------------------+----------------------------+|character_set_client|utf8||character_set_connection|utf8||character_set_database|latin1||character_set_filesystem|binary||character_set_results|utf8||character_set_server|latin1||character_set_system|utf8||character_sets_dir|/usr/share/mysql/charsets/|+--------------------------+----------------------------+

character_set_database是数据库的编码格式

创建一个test表查看其默认的编码格式

show create table test;

+-------+-------------------------------|Table|CreateTable|+-------+-------------------------------|test|CREATETABLE`test`(`id`int(11)NOTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=latin1|+-------+-------------------------------

DEFAULT CHARSET=latin1默认的编码格式是latin1,与数据库编码格式相同

更改配置文件/etc/my.cnf

添加设置:

[client]default-character-set=utf8[mysqld]character-set-server=utf8collation-server=utf8_unicode_ci

本机进入数据库

查看编码格式:

status

Servercharacterset:utf8Dbcharacterset:utf8Clientcharacterset:utf8Conn.characterset:utf8

show variables like 'char%';

+--------------------------+----------------------------+|Variable_name|Value|+--------------------------+----------------------------+|character_set_client|utf8||character_set_connection|utf8||character_set_database|utf8||character_set_filesystem|binary||character_set_results|utf8||character_set_server|utf8||character_set_system|utf8||character_sets_dir|/usr/share/mysql/charsets/|+--------------------------+----------------------------+

创建数据库查看其编码

与上面相同

创建表查看编码:

+-------+------------------------------------------------------|Table|CreateTable|+-------+------------------------------------------------------|test|CREATETABLE`test`(`id`int(11)NOTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8COLLATE=utf8_unicode_ci|+-------+-----------------------------------------------------

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci默认的编码格式与配置相同