Re: case insensitive primary key

[Timothy Wu]

On 10/16/06, mos <[EMAIL PROTECTED]> wrote:

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

The binary attribute allows me to store the same entry with different caps,
thanks.

Timothy