Apply OS: Windows, Mac, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All


By default, MySQL will save the table name with lowercase. One way to avoid lowercase problem of MySQL server is to start mysqld with -O lower_case_table_names=0. By default this option is 1 on Windows and 0 on Unix. If lower_case_table_names is 1, MySQL will convert all table names to lower case on storage and lookup. Note that if you change this option, you need to first convert your old table names to lower case before starting mysqld.

For more information, please refer to - http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Have more questions?
Submit Ticket