On Aug 27, 2009, at 5:11 PM, Adrian Aitken wrote:
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.
That should not happen. Column names are not case sensitive in MySQL.
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html:
Column, index, and stored routine names are not case sensitive on any
platform, nor are column aliases.
Can we see your query?
Regards
Adrian
----- Original Message -----
From: Scott Haneda
To: Adrian Aitken
Cc: mysql@lists.mysql.com
Sent: Thursday, August 27, 2009 11:04 PM
Subject: Re: Getting mySQL to ignore case sensitivity of field names
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
You need to set the field format to a non binary one, and case
insensitive will be the default.
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
