MySQL/Linux Tables Case Sensitive

[TomBarrand]

Hi,

I have moved an application that we have written from running on Windows with SQL Server to running on Linux with MySQL.

Since I have moved the application I am finding issues as MySQL/Linux seems to be case sensitive with how table names are referenced. In SQL Server you can use SET IGNORECASE TRUE to force it to ignore the case.

Is there anyway to do this in MySQL/Linux?

Thanks

 

[TonyGroves]

Since databases are mapped to directories, and MyISAM tables are mapped to files, case-sensitivity depends on the filesystem used. Windows filesystems are not case-sensitive, but Linux systems usually are. However, you can set the variable lower_case_table_names=1 in your my.cnf to convert all table references to lower-case, which effectively makes them case-insensitive. Of course, your file and directory names must also be lower-case for this to work.