At 08:26 AM 10/15/2006, you wrote:
Hi,

My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key case
insensitive. Is this normal? This is not the behavior I prefer. Any help
would be appreciated, thanks.

Timothy

Timothy,
You can make the varchar column case sensitive by using the binary attribute or use the isstrcmp(value1,value2) for an exact match.

See http://lists.mysql.com/mysql/170390
varchar(255) binary

or select binary 'a'='A' ...

Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to