Getting mySQL to ignore case sensitivity of field names

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=gcdmg-mysql-2@m.gmane.org

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.

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=gcdmg-mysql-2@m.gmane.org

Re: Getting mySQL to ignore case sensitivity of field names

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=gcdmg-mysql-2@m.gmane.org

Re: Getting mySQL to ignore case sensitivity of field names

Oops, sorry about that. My understanding is this is OS dependent:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensi tivity.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=gcdmg-mysql-2@m.gmane.org

Re: Getting mySQL to ignore case sensitivity of field names

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-sensi tivity.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=gcdmg-mysql-2@m.gmane.org