Welcome Guest | Login

How to control MySQL Table Name Case Sensitivity?

I would like for table names in MySQL to be case insensitive when I query them but I can't see how to control this.

i.e.  I would like the two quoted queries

"  Select * from Batch;  "

and

"  Select * from batch;  "

to both return the entire contents of the BaTch table instead of "table DBName.Batch does not exist" and "table DBName.batch does not exist"

Is this possible on Linux?  I know it works on a windows MySQL setup.

2008-07-01 09:06 PM

Rithm, LLC
Both the select statements should return the correct values now.
Please verify.

2008-07-01 10:59 PM

We've reverted the configuration changes done to enable the case insensitivity. This seemed to have bad effects on other databases on the server. We'll see if this is possible on a MySQl server which hosts both InnoDB and ISAM table types.  

2008-07-02 05:41 AM

Hi Brent,

Please note that the linux machine is case sensitive in nature so in order to make the mysql case insensitive the possible way is to change the global settings of mysql. ie to treat the sql queries in either lower or in upper. But the changes given to the global settings may affect the other users in the shared server. So due to  various reasons we can't provide this feature in our shared server. We will update you through this forum link itself if we have found any other alternatives in future.

2008-07-02 06:53 PM


Hello Guest! In order to post you must be an active client with us, please log in or sign up today!