Is there a way that I can get the table names to be saved in the case that I enter them in?

Apply OS: iOS

Apply Navicat Product: Navicat for MySQL

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.
Have more questions? Submit a request

0 Comments

Article is closed for comments.