mysql table and field cases

[jackvull]

Is there a way to get PHP and MySQL to ignore table and field cases on Linux?
Seems to work fine on windows but when transferring code to a Linux server
SELECT * FROM TableName no longer works...

it has to be the correct case
SELECT * FROM tablename

[eelixduppy]

You may be able to find just what you are looking for here [dev.mysql.com]. Good luck!

[vincevincevince]

It comes down to the fact that filenames in general are case-sensitive with linux/unix systems (well, most of them).

There are some partial work-arounds in the manual page referenced above, but I recommend that you pick a case and stick with it. I only ever use lower case for tables and databases.