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