Database/Table name case issue

crtcrt · Post by **crtcrt** » Sat 17 Sep 2011 23:25

I'm currently reviewing Studio for MySQL V5.0.48 and really like it however I came across a serious problem. The Database Explorer doesn't honor the case sensitivity of the database/table names. We had a couple of database migrations that occurred and inherited some database names that are both UPPER and lower case. This is perfectly legal in case sensitive file systems (Linux) and I do admit it probably doesn't rank up there on the best practice list. Never the less, I have to support this.

As a test I created two Databases, one with the names completely in upper case (DB, table and columns names), the other all lower case. In the other clients that I'm reviewing I get two distinct database listings and have no issues working with either database:

When viewed in dbForge I get a strange mix:

This results in both databases more or less unusable from dbForge.

Regards,
Chris

Duke · Post by **Duke** » Mon 19 Sep 2011 10:27

This is a known issue. Because of the deeper problems with MySQL metadata, which might be hidden in your case, we decided to assume that there are no databases (database objects) on one server with names differing ONLY in letter case.