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:

Last update: 2005-09-21 05:21
Author: Peter Laursen
Revision: 1.0

{writeDiggMsgTag} {writeFacebookMsgTag} {writePrintMsgTag} {writeSend2FriendMsgTag} {writePDFTag}
{translationForm}
Rate this FAQ

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ