Oops, sorry about that. My understanding is this is OS dependent:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
You may be able to set lowercase tables names, but would always have
to use lowercase. I would just stick to entering in the correct case,
as the other methods seem prone to trouble.
On Aug 27, 2009, at 3:04 PM, Scott Haneda wrote:
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
