List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:April 26 1999 8:43pm
Subject:Re: Selects with case sensitivity
View as plain text  
Sasha Pachev wrote:
> Barry wrote:
> >   Select * from Auth where User='barry' and strcmp(Pwd,'Sch')=0
> > 
> > It does what I want. Is this the best way?
> 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.

Or you could add the BINARY attribute to have your char column be
compared case sensitively (MySQL V3.21.0 and above).

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Looking for ISP that provides MySQLChristopher R. Jones26 Apr
  • Re: Looking for ISP that provides MySQLBill Gerrard26 Apr
  • Re: Looking for ISP that provides MySQLBill Rhodes26 Apr
    • Selects with case sensitivityBarry26 Apr
    • Re: Looking for ISP that provides MySQLChris Jester27 Apr
    • Re: Looking for ISP that provides MySQLKyle Cordes27 Apr
      • Re: Looking for ISP that provides MySQLJohn Elliott27 Apr
  • Re: Selects with case sensitivitySasha Pachev27 Apr
    • Re: Selects with case sensitivityThimble Smith27 Apr
      • Problems with BINARY keywordRichard Antecki28 Apr
        • Re: Problems with BINARY keywordFred Read28 Apr
        • Re: Problems with BINARY keywordVladimir Berezniker29 Apr
        • Problems with BINARY keywordMichael Widenius11 May
    • Re: Selects with case sensitivityMartin Ramsch27 Apr
      • Re: Selects with - ThanksBarry27 Apr