MySQL set case sensitive

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 alias of the column name and column is ignored in all cases;
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  VARCHAR(tenBINARY);

B. Modify with Alter:

ALTER TABLE COLUMN VARCHAR (BINARY;

C, the MySQL table editor directly tick binary items.

MySQL set case sensitive