Case Sensitive Problem

[swing]

First off, I am guessing this is a bug as i cannot see any logical benefits for the application to behave in this mannor. If I am wrong then id be grateful for your thoughts.

I have noticed that when creating a table with a mixed case name (i.e. “table_emailAddress“) the application converts the name to lowercase. This is reducing the control the user has on the database naming standards, something I cannot see why a GUI should have control over.

If you select the table and click F2 (to rename the table) you are actually able to change the table from “table_emailaddress” back to “table_emailAddress“. However once you refresh the database the issue is regressed.

As the lowercase table name is harder to read, I would reconsider my chosen table names. It seems such a small issue but if it was intential I do not agree with the application having this much control over the users naming standard preferences.

Is this a fix that can be released in a future service pack?

Regards,

Russell

[CalEvans]

Hi,

This is an issue with mysql on windows, not with sqlyog. It's been discussed here before.

=C=

p.s., It's not an issue with mysql on any other platform.

[Shadow]

As of now, Windows does not differentiate between cases in file names meaning that “filename.frm” and “FileName.frm” names yield to the same file. Currently MySql databases are “stored” as folders and tables as files (even when InnoDB is used!), so naming is affected by how the OS stores their names. This is why you have only lowercased db and table names on Windows.

Besides, there is a setting in MySql called lower_case_table_names. On Windows this value defaults to 1 (true). If this value is set to this value, then your table names will be always in lower case regardless of you OS.

[Author]

Posts