查看编码的方法:
1:查看表内各个字段的编码
show create table TableName 或 show full columns from tableName
show full fields from tbl_mx;
2:产看数据库的编码:
SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
| 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
character_set_server默认字符集
使用命令修改编码(有时无效,重启后也会失效):
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
修改配置文件
在windows下mysql配置文件好像叫my.ini
如果无法更改数据库配置文件,可以采取一下方法(不保证全部有效):
1、建数据库时设置数据库编码为utf-8
例如 create database `cyun2015a` default character set utf8;
1:查看表内各个字段的编码
show create table TableName 或 show full columns from tableName
show full fields from tbl_mx;
2:产看数据库的编码:
SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
| 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
character_set_server默认字符集
使用命令修改编码(有时无效,重启后也会失效):
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
修改配置文件
在windows下mysql配置文件好像叫my.ini
如果无法更改数据库配置文件,可以采取一下方法(不保证全部有效):
1、建数据库时设置数据库编码为utf-8
例如 create database `cyun2015a` default character set utf8;