MySQL problem with capitalization

MySQL under Linux database, table name, column name, alias rules:

1. Database name and table name are strictly case-sensitive;

2. The alias of the table is strictly case-sensitive;

3. Variable names are strictly case sensitive;

4. Column names and column aliases ignore case.

MySQL is not case-sensitive under Windows.

Reason:

MySQL in the query string is case insensitive, in the compilation of MySQL generally with the ISO-8859 character set seat default character set, this character set is not sensitive to case, so in the comparison process of Chinese encoded character case conversion caused this phenomenon.

Solution:

1. The table name is case-sensitive;

Join in My.conf

Ower_case_table_names = 0

0: Case Sensitivity 1: case-insensitive

2. Field value Set binary property

Can be case-sensitive

Below are the problems I have encountered in the project:

A few days ago when doing a project (Linux environment), accidentally shook hands, created two table names the same database, while writing SQL query database, will appear

SELECT * FROM SWXX_ZXWD and select * from SWXX_ZXWD

Two different kinds of results.