Database/Table name case issue

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
crtcrt
Posts: 4
Joined: Wed 14 Sep 2011 06:51

Database/Table name case issue

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:

Image

When viewed in dbForge I get a strange mix:

Image

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

Regards,
Chris

Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

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.

Post Reply