PDA

View Full Version : Tables and capitalization



Keleth
07-16-2011, 12:07 AM
I recently formatted my PC and noticed today that on my local machine, tables do not keep capitalization in names (eg, if create a table 'forumAdmins' it becomes 'forumadmins'). I've noticed it doesn't care about capitalization (queries with table references ignore capitalization), but tables on my server do maintain and care about capitalization.

I'm not well versed in mySQL settings... is this a setting issue? Or a version issue? Should I care?

oracleguy
07-16-2011, 12:16 AM
It is a setting and platform issue, see: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names