List:General Discussion« Previous MessageNext Message »
From:Werner Stuerenburg Date:June 27 2001 11:11pm
Subject:Re: Bug in Like with longblob
View as plain text  
> I suppose I found a bug :-)
> According to  LIKE in a SELECT-query is case-insensitive. In fact, 

Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB


The only difference between BLOB and TEXT types is that sorting
and comparison is performed in case-sensitive fashion for BLOB
values and case-insensitive fashion for TEXT values. In other
words, a TEXT is a case-insensitive BLOB.


-- 
Herzlich
Werner Stuerenburg            

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de


Thread
Bug in Like with longblobTobias Eggendorfer27 Jun
  • Re: Bug in Like with longblobColin Faber28 Jun
  • Re: Bug in Like with longblobWerner Stuerenburg28 Jun
  • Re: Bug in Like with longblobPaul DuBois28 Jun
  • Re: Bug in Like with longblobSherzod Ruzmetov28 Jun