mysql数据库编码的查询

mysql> SHOW  VARIABLES  LIKE   'char%';
+————————–+——————————————–+
| Variable_name            | Value                                      |
+————————–+——————————————–+
| character_set_client     | latin1                                     |
| character_set_connection | latin1                                     |
|  character_set_database  | gbk                                        |
| character_set_filesystem | binary                                     |
| character_set_results    | latin1                                     |
| character_set_server     | gbk                                        |
| character_set_system     | utf8                                       |

| character_sets_dir       | /mysql/mastermysql50/share/mysql/charsets/ |

数据库大小写敏感问题

转自：blog：http://blog.csdn.net/wocjj/article/details/7415200

查看大小写区分

mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   | 
| lower_case_table_names | 0     |     //0区分 1不区分
+------------------------+-------+

2 rows in set (0.00 sec)

LINUX下的MySQL默认是要区分表名大小写的。
　　让MYSQL不区分表名大小写的方法其实很简单：
　　1.用ROOT登录，修改/etc/my.cnf
　　2.在[mysqld]下加入一行：lower_case_table_names=1
　　3.重新启动数据库即可

#service mysqld restart 重启即可解决