table case sensitivity

[arathra]

Is there a quick way to change a DB so that when passing a SQL query the table names are NOT case sensitive? This is on a Windows server.

 

[Stephen]

what is the SQL server, MSSQL oy mySQL?

 

[arathra]

MySQL. The server is unix but the code is from ASP so it's on Windows.

 

[Stephen]

MySQL is on unix, so it will always be case sensitive.

 

[arathra]

I didn't know if it were possible to use the lower_case_table_names system variable to set this before the MySQL was started so that code containing uppercase table names could refer to lowercase tables on the server.