Bug #1877 Table creation not respecting specified case

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.

Here is a sample log of the problem.

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

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