Mysql Case sensitivity solution in linux, linuxmysql

Mysql Case sensitivity solution in linux, linuxmysql

1. After mysql is installed in Linux, the default value is: case-sensitive for table names, not case-sensitive for column names;

 

2. log on to the/etc/my. add lower_case_table_names = 1 after [mysqld] In cnf and restart the MYSQL service. The setting is successful: The table name is case-insensitive;

Lower_case_table_names parameters:

Lower_case_table_names = 0

 

0: Case Sensitive, 1: case insensitive

In Linux, the database name, table name, column name, And alias are case-sensitive:

1. The database name and table name are case sensitive;

2. Table aliases are case sensitive;

3. The column name and column alias are case-insensitive in all cases;

4. Variable names are case sensitive;

MySQL is case insensitive in Windows.

 

3. If you want to query the case sensitivity of the time zone field value, you need to set the BINARY Attribute for the field value. You can set multiple methods:

A. set at creation:

Create table t (

A varchar (10) BINARY

);

B. Use alter to modify:

Alter table 'tablename' modify column 'cloname' VARCHAR (45) BINARY;

C. Select BINARY in mysql tableeditor.