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 |
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 0 | //0区分 1不区分
+------------------------+-------+
+————————–+——————————————–+
| 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 重启即可解决