Getting mySQL to ignore case sensitivity of field names

[Adrian Aitken]

Hi, Google isn't my friend :-(
How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName 
should also be able to be referenced as fullname,fullNAME etc ?
I'm running it on a linux box at home but my copy at work (running on 
Windows 2000 server) has this by default - I certainly set any options.
When I Google all I seem to get are hits about ignoring case in select query 
values not field names.

Many thanks
Adrian 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Getting mySQL to ignore case sensitivity of field names

[Adrian Aitken]

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: 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.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org