Results 1 to 3 of 3
Thread: MySQL case sensitivity
-
03-09-2004, 02:18 PM #1Web Hosting Master
- Join Date
- Jun 2000
- Location
- Washington, USA
- Posts
- 5,990
MySQL case sensitivity
Anyone have a work-around for case sensitive database and table names?
E.g. you can reference the database in both upper and lower case.
For reference the server is running FreeBSD and it's MySQL version 3.23.56
-
03-09-2004, 02:44 PM #2Web Hosting Master
- Join Date
- Jun 2003
- Posts
- 673
Check out this page from the MySQL docs. There is a lower_case_table_names options to control this (dunno if it's supported in 3.23). If you set it to 1, you will need to stop MySQL and rename your files and directories to lowercase first.
-
03-09-2004, 02:52 PM #3Web Hosting Master
- Join Date
- Jun 2000
- Location
- Washington, USA
- Posts
- 5,990
Thanks!