Hi everybody, I've got a MEDIUMBLOB column in a table, where I want values to be unique. So I made it UNIQUE. When my program wants to enter a value, it first does a select * from table where column =x in order to see if x already exists, if not, it does an insert. Now the interesting point: If there is c1ccccc1 in the column and I want to insert C1CCCCC1, the select says, that this is not existing, so the insert is done. Then mySQL complains about double keys. It seems that the UNIQUE comparision is not done case-sensitive in BLOB-columns, which is bad. Does anybody have an idea about how to solve this (I need the column to be case-sensitive). Many thanks Stefan
-- Stefan Kuhn M. A. MPI of Chemical Ecology, Winzerlaer Str. 10, Beutenberg Campus, 07745 Jena, Germany Tel: +49(0)3641 571261 - Fax: +49(0)3641 571202 --------------------------------------------------------------------- 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
