VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> How can I have an UNIQUE key in MYSQL which
> differentiates between case sensitive strings.i.e If I
> want to store "XYZ","XYz" and "xyz"
> differently.Currently mySQl is not accepting this type
> of strings and treating them as the same.
>
> Regards,
> Ravi
You need to use the binary keyword when creating the column
http://www.mysql.com/doc/C/H/CHAR.html
or you can alter the column and add the binary key word, otherwise
char and varchar are not compared with consideration of case
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php