Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Case sensitive database names in MySQL

vrs-webmaster's profile image vrs-webmaster posted 11 months ago in General Permalink

On our MySQL server, the first part of the database name is the same. The last character can be a digit, a capital letter, a small letter or a special character. However, if there are two databases called xxxxxxx_E and xxxxxxx_e, only the one with the capital E is displayed in the database list. Why? And how can I do that both databases should appear in the list.

VRS-webmaster

ansgar's profile image ansgar posted 11 months ago Permalink

I suppose then it's a bug in HeidiSQL - the databases are maybe internally case insensitive, and one overwrites the other one. If you are sure there are two databases, you should file a bug report in the tracker.

vrs-webmaster's profile image vrs-webmaster posted 11 months ago Permalink

I'll do that. And yess I am shure - I've created them my self and I can see them in phpMyAdmin.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.