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: | |
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 ]
[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