ASP, My SQL & case sensitity suddenly broken

Question

Hi There,

We have an old ASPsite that has been working fine for years with a MY SQL database. All of a sudden last week lots fo SQL queries stopped working.

The database has a table called 'members' but the code calls 'Members'. It appears the queries used to work regardless of case sensitivity on the table names, but something has changed recently somewhere to enforce case.

This has me stumped as the site has not been touched in years, the server config hasn't changed & the database provide has not changed anything.

Is there any simple way to ignore case for an ASP site (without editing lots fo files :)

Thanks

Ben

Answer 1

Have a look at this page from the manual to learn about case-sensitivity and identifiers in MySQL.

Someone may have switched the lower_case_table_names toggle, or (as webdestroya comments) moved the database server from a case-insensitive OS (e.g. Windows) to a case-sensitive OS (e.g. Linux).