The case of MySQL database in Linux environment

1, Linux under the installation of MySQL is the default: distinguish the case of the table name, do not distinguish between the case of the column name;
2, with the root account login, in the/ETC/MY.CNF [mysqld] After adding add Lower_case_table_names=1, restart the MySQL service, this time has been set success: not distinguish between the case of the table name;
Lower_case_table_names parameter Details:
Lower_case_table_names = 0
Where 0: Case sensitive, 1: Case insensitive
MySQL under Linux database name, table name, column name, alias casing rules are like this:
1, database name and table name are strictly case-sensitive;
2, the table alias is strictly case-sensitive;
3, the column name and the alias of the column in all cases are ignored case;
4, variable names are also strictly case-sensitive;
MySQL is case insensitive under Windows.
3, if you want to distinguish the case of the field value when querying, then: The field value needs to set the binary property, there are several ways to set it:
A. Set at creation time:
CREATE TABLE T (
A VARCHAR (Ten) BINARY
);
B. Modify with Alter:
ALTER TABLE ' tablename ' MODIFY COLUMN ' cloname ' VARCHAR BINARY;
C, the MySQL table editor directly tick binary items.
Reprint please indicate source: MySQL database case sensitivity problem in Linux environment

Ding Feng Xiao Hu
qq.2881064155
[Email protected]

The case of MySQL database in Linux environment