SQL is not a case sensitive language.whether your table is named "mYtable" or "MyTable" the query:
SELECT * FROM mytable
will still return results.
it is best practice in MySQL however to use all lowercase for table and database names, column names can be mixed case.
OK, ill change all my table names to lower case so as to follow best practices.
But, there is a problem with the WebAssist tools when it comes to case.
I used DataAssist to update a record and I get a mysql error when the following line...
$WA_table = "survey";
in the update block has the lower case 's' in 'survey' and the table name is upper case 'S' for the table named 'Survey' in the database.
If I change the case of the lower case 'survey' to upper case 'Survey' the query works for the table named 'Survey'.
So SOMETHING is checking the case of the $WA_table value.
Also, a second problem comes up when I import and export the tables. If I export lower case table names then import them into the database with upper case names I get duplicate tables.
So... SOMETHING in the MySQL database IS checking case and importing the tables as duplicates if the case does not match.
This leeds me to believe that you could be wrong when you say that MySQL does not care about table name case.
---
