[RESOLVED] Issue with case sensitive table names in queries

[Fooglmog]

So, I've been developing a site on my WAMP server which runs great there. But last night I moved it over to my web host and suddenly started to discover a thousand and one errors.

What I traced it down to is that my local server treats this query:

SELECT posts_count FROM usercake_Threads WHERE thread_id = 1 LIMIT 1

The same as as it treats this query:

SELECT posts_count FROM usercake_threads WHERE thread_id = 1 LIMIT 1

While my web host does not.

As you can see, it's just a problem with case sensitivity when determining the table. But, I have an awful lot of these queries in my site and they aren't standardized one way or the other... so it would be a huge amount of work to convert them all.

Does anyone know why it's case sensitive on one DB and not on the other? My first thought was collation, but they're both using the default latin1_swedish_ci... and after that I ran out of ideas.

[NogDog]

Because Linux (and UNIX) treats file names in a case-sensitive manner while Windows does not, and in MySQL there is a one-to-one relationship between table names and the files used for them. See http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html for more info, and to determine if the lower_case_table_names variable can help or not (I'm not sure).

[Fooglmog]

Ahhh, thank'ee kindly.