SQLyog MySQL Admin FAQ - UPPERCASE in table names are LOWERCASE'd

SQLyog MySQL Admin FAQ

Navigation

2 users online | 2 Guests and 0 Registered

Latest FAQs

SQLyog Version History (2014-06-08 10:22)
I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
About CHUNKs and BULKs (2014-01-09 11:53)
SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)

Sticky FAQs

MySQL bugs that affect SQLyog

ID #1013

UPPERCASE in table names are LOWERCASE'd

The early releases of MySQL server series 4.1.x had a bug that was corrected with the release of MySQL version 4.1.13. In the MySQL bugs repository it is described here: http://bugs.mysql.com/bug.php?id=9660 .

This bug means that the server directive lower_case_table_names=2 does not have effect on InnoDB tables when server is running on Windows platform.

As a consequence of that the SQLyog CREATE TABLE and ALTER TABLE dialogues cannot save UPPERCASES in table names. They are saved as LOWERCASE.

Tags: -

Related entries:

You can comment this FAQ