Hi, I'm not sure if this is a bug or desired behavior, but when running MySQL under Windows, Toad does not allow capital letters in table names.
When creating a table, the name will automatically be changed by Toad to all lowercase. So if you enter "articleLocations", Toad will store this in MySQL as "articlelocations".
As long as the database remains under Windows, this is not a problem of course. But when you move a database to a Linux environment, all sorts of problems arise.
In our code we stick to our naming conventions of lowerCamelCase for pretty much everything. Strangely, in database and in column names Toad does allow the use capital letters; only in table names this seems to be forbidden.
I'm not sure if this is a feature or a bug, and if it is a bug I'm not sure if it is a bug in Toad or in MySQL for Windows. I do know that it is a bit of a hassle to have to rename all tables every time when moving a database from Windows to Linux. It obviously takes an extra round of debugging, too. A lot of work for something that seems to be a trivial matter.
So basically I have two questions: would this be something I should submit a bug Toad report for? And, more importantly perhaps: does anybody know a work around?