List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 25 2001 6:19pm
Subject:Re: String Comparision
View as plain text  
At 11:23 PM -0500 11/24/01, Gary Huntress wrote:
>I have a table of user info containing mixed case text.   One user has
>created a database named "brain" and another has created a database "Brain".
>I was surprised to see that:
>select * from users where dbname= "Brain" returns both "brain" and "Brain".
>I read section and select binary dbname from users where
>dbname="brain" also returns both records.

SELECT dbname FROM users WHERE BINARY dbname = "brain"


>This surprises me.   Have I missed another option somewhere?
>Gary "SuperID" Huntress
> offering free database hosting to developers

String ComparisionGary Huntress25 Nov
  • Re: String ComparisionPaul DuBois25 Nov
Re: String ComparisionMarjolein Katsma25 Nov