From: Fred Lindberg
Date: March 22 1999 7:07pm
Subject: Re: case sensitive and BLOBS
List-Archive: http://lists.mysql.com/mysql/786
Message-Id: <19990322190931.8108.qmail@id.wustl.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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)