Re: Selects with case sensitivity

[Thimble Smith]

On Mon, Apr 26, 1999 at 02:15:03PM -0600, Sasha Pachev wrote:
> > Auth
> >   User  char(32)
> >   Pwd   char(16)
> > 
> >   Select * from Auth where User='barry' and strcmp(Pwd,'Sch')=0
> > 
> > It does what I want. Is this the best way?

No, it's likely to be quite a bit slower than the other solutions.

> There is an alternative way, I do not now if it is any
> better. Make your data type blob instead of char, and
> then = operator will be case-insensitive.

s/insensitive\./sensitive./

Instead of declaring it as a BLOB, just use the BINARY keyword
when you define the field.  Look at the CREATE TABLE docs for
more info on the BINARY attribute.  Obviously, you'll want Pwd to
be BINARY and User to be normal.

Tim