table case lost

[ngj]

When creating a table, the case of the spelling is lost when the UI displays it. For example if I create a table called DefaultFolders, the UI object browser then displays it as defaultfolders.

True, it's a minor inconvenience, but it's irritating. It's also internally inconsistent because column names retain case, as expected.

Hopefully this will get fixed.

[Ritesh]

I believe that your MySQL server is running on Windows.

From the MySQL Docs:

Quote:

On Unix, you can have two different tables named my_table and MY_TABLE, but on Windows those names are considered the same. To avoid data transfer problems stemming from database or table name lettercase, you have two options:

• Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you don't see the names in their original lettercase.
• Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that you always refer to your database and table names with the correct case on Windows as things will not work on Unix if you use the wrong lettercase (as Unix is case sensitive).

On Windows, filenames are not case sensitive, so MySQL database and table names are also not case sensitive on Windows.

[Author]

Posts