Case Insensitive MySQL Database
On my MySQL database, my collation is set to utf8_general_ci. I also checked the collation of table in my database. This should allow for case insensitive queries. However all queries are still are still case sensitive.
For example, this query will not work if I have the username with the first letter capitalized.
SELECT * FROM users WHERE username = 'test' AND password = 'test'
I am using MySQL 5.5.27 Community edition. Thanks.
Your collation set to ci (case-insensitive) only affects the way you search in data, not columns. IIRC, column names are case sensitive and table names aren't.
Follow a standard naming convention for your database.