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.
On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote:
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.
--
Scott * If you contact me off list replace talklists@ with scott@ *
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org