WampServer

Is there any way to change the table name sensitivity on windows? All of the table names are created with lower case, so when I export to import onto the live linux server, all of the names in my code don't match the table names. I am writng my code with upper and lower case camel string table names, ie:

appUser
playerName

etc. Now, thankfully, I can strtolower almost evertyhing in my db abstraction, but that's really stupid... Any ideas? I

Hi,

Your options are documented in [dev.mysql.com]. For maximum portability and ease of use, MySQL recommends lower case database and table names.

Please note the warning about changing the default setting of the system variable lower_case_table_names in case-insensitive file system like Windows. If you refer to the table in wrong lettercase, index corruption may occur.


Regards,

toivo
Sydney, Australia