Case sensitive in sql statement > MySql db..?

Hi

Just a qustion, probably me being slack due to MS Access allowing non case sensitive matches in sql statements, but weird.

The XAMPP on the machine appears to allow it (ie SELECT * FROM tblUsers or SELECT * FROM tblusers) but the one I'm hosting on (free and just to show other people) wont open the queries unless the tables match exactly.

Is there a setting on MySql that can allow any case sensitive naming..?
Or is it a setting on the PHP Online server (older version I think)..?

Are you using a non-Windows OS by any chance?

http://dev.mysql.com/doc/refman/5.0/...nsitivity.html

Ah hmmm maybe.. Windows here... but the server on the free hoster might be unix or linux...

Ok that makes sense.

Thanks :)