PHP/mySQL Case Sensitivity

[ukgimp]

I have been working locally and all is well. When I upload to a different server it all goes Pete Tong.

I did some stuff locally and did not pay attention to the case of the sql as a resutl soem tables are not recognised. More of a pain than a case of life and death.

I was just wondering if I have a setting locally that is causing this:

com.autoregister_casesensitive

perhaps?

Regards

[daisho]

the mysql server *IS* case sensitive. As is Apache on *NIX (Unless you use mod_spelling which makes apache seem like it's not)

Your best bet is to *ALWAYS* create table names in lower case.

The problem arises if you are testing on Windows then upload to a *NIX box. Windows is *NOT* case sensitive and I believe theirfor neither is mySQL or PHP on windows.

A general rule of thumb is to always use lower case and avoid the problems all together.