table case sensitivity

arathra · September 23, 2007, 11:36am

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 · September 23, 2007, 1:52pm

what is the SQL server, MSSQL oy mySQL?

arathra · September 23, 2007, 1:55pm

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

Stephen · September 23, 2007, 2:16pm

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

arathra · September 23, 2007, 2:33pm

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.