From: Adrian Aitken (adrianitken.com)
Date: Thu Aug 27 2009 - 17:11:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.

Regards
Adrian

----- Original Message -----
From: Scott Haneda
To: Adrian Aitken
Cc: mysqllists.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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]