Bug #1877 Table creation not respecting specified case
Submitted: 18 Nov 2003 11:42 Modified: 19 Nov 2003 9:08
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:Ver 12.22 Distrib 4.0.16, for Win95/Win9 OS:Windows (Microsoft Window XP 5.1)
Assigned to: CPU Architecture:Any

[18 Nov 2003 11:42] [ name withheld ]
Description:
$ mysql -V
c:\mysql\bin\mysql.exe  Ver 12.22 Distrib 4.0.16, for Win95/Win98 (i32)

$ uname -a
CYGWIN_NT-5.1 SCHRECKTECH004 1.5.5(0.94/3/2) 2003-09-20 16:31 i686 unknown unknown Cygwin

Microsoft Windows XP; Media Center Edition; Version 2002; Service Pack 1

The client recognizes the case sensitivity during SQL commands but the tables are not stored case sensitive.  This is a problem during importing from and exporting to case-sensitive platforms.

The dump from this table writes an incorrect case for the table, but a correct one for the column?

How to repeat:
Create a table with the build labeled above on the platform above with backquoted named table with mixed case.  The resulting table seems to always be lowercased.

Suggested fix:
Use the specified case.
[18 Nov 2003 11:44] [ name withheld ]
Here is a sample log of the problem.

Attachment: sample.log (application/octet-stream, text), 1.54 KiB.

[19 Nov 2003 9:08] MySQL Verification Team
By default the MySQL server has enabled the lower_case_table_names:

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%lower%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | ON    |
+------------------------+-------+
1 row in set (0.01 sec)

if you want to change this behavior use on your my.cnf/my.ini file
the below option:

set-variable	= lower_case_table_names=0