Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Adrian Aitken (adrianitken.com)
Date: Thu Aug 27 2009 - 17:11:10 CDT
Hi Scott, it's not the values I have a problem with, it's the fieldnames
themselves. As an example the mysql.user table has 'Host' but when I do an
update setting 'host' to a value it fails to update. I have to enter 'Host'.
The mysql.com link seems to only talk about field values.
----- Original Message -----
From: Scott Haneda
To: Adrian Aitken
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
You need to set the field format to a non binary one, and case
insensitive will be the default.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql