...

View Full Version : Tables and capitalization



Keleth
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?

oracleguy
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