List:General Discussion« Previous MessageNext Message »
From:Fred Lindberg Date:March 22 1999 7:07pm
Subject:Re: case sensitive and BLOBS
View as plain text  
On Mon, 22 Mar 1999 13:57:52 -0500, efrazier@stripped wrote:

>do a case IN sensitive search. Is this something weird about long blobs or
>am I just messing something up? 

I think you need to use TEXT if you want it case-insensitive:

7.2.7.2 The BLOB and TEXT types
A BLOB is a binary large object that can hold a variable amount of
data. The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB
differ only in the maximum length of the values they can hold. See
section 7.2.1 Column type storage requirements. 

The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT correspond
to the four BLOB types and have the same maximum lengths and storage
requirements. 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. 


-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)


Thread
case sensitive and BLOBSefrazier22 Mar
  • Re: case sensitive and BLOBStony22 Mar
  • Re: case sensitive and BLOBSPaul DuBois22 Mar
Re: case sensitive and BLOBSFred Lindberg22 Mar