Mysql is case insensitive (case insensitive) _ MySQL

The following table is used to differentiate the case sensitivity of mysql in windows and linux by default. operating system table name variable name segment 20540; windows is not sensitive, linux is not sensitive, linux is sensitive, and linux is not described. The following table is used to distinguish the sensitivity of mysql to the case in windows and linux by default.

Operating system	Table name	Variable name	Field value
Windows	Insensitive	Insensitive	Insensitive
Linux	Sensitive	Sensitive	Sensitive

I will not describe it in linux first, because it has not been actually used. The following describes how to modify it in windows:

Alter the case sensitivity of table names:

Lower_case_table_names = 0
0: Case Sensitive, 1: case insensitive

Field value modification:

1. set at creation: create table t (
A varchar (10) BINARY );
2. use alter to modify:
Alter table 'tablename' modify column 'cloname' VARCHAR (45) BINARY;

3. use database management tools to modify

Note: you cannot directly change table Collection to bin (utf8_bin if the database character encoding attribute is UTF-8) to make all fields take effect. you must change one field to another.