Table names / upper and lower case

[m175400]

When I make changes to my table structures it renames my table to all lowercase, for instance tblLatestNews to tbllatestnews. When I export a table to batch scripts, or a db, it seems to mix up the upper and lower case which generates errors when you try and execute it because it is trying to add records to tblLatestNews rather than tbllatestnews, which on one hand it has decided to change the case of but has still exported batch-script-wise in the original format. Very odd. I have to change the table name to something else first, then back and with the appropriate case because else it thinks I am changing the name to the same as another table already because it doesn't realise the difference between the case. ARGH!

Anything I can do change this?

[Ritesh]

Check out:

http://dev.mysql.com/doc/mysql/en/Name_cas…ensitivity.html

[Author]

Posts