MySQL is case insensitive (case insensitive)

Use a table below to differentiate how sensitive MySQL is to uppercase and lowercase by default in Windows and Linux

Operating system	Table name	Variable name	Field value
Windows	Not sensitive	Not sensitive	Not sensitive
Linux	Sensitive	Sensitive	Sensitive

Linux does not introduce the first, because there is no actual use, the bottom of the next under the Windows modification method:

Table name case-sensitive modification:

Lower_case_table_names = 0
Where 0: Case sensitive, 1: Case insensitive

Modification of field values:

1. Setup at creation time: Create TABLE T (
A VARCHAR (Ten) BINARY );
2. Modify with Alter:
ALTER TABLE ' tablename ' MODIFY COLUMN ' cloname ' VARCHAR BINARY;

3, the use of database management tools to change

        Note: You cannot change the collection of the table directly to bin (if the database character encoding property is Utf-8 Utf8_bin) for all fields to take effect, a field must be changed