View Full Version : Tables and capitalization

07-15-2011, 11:07 PM
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?

07-15-2011, 11:16 PM
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

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum