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 6.3.2.2 and select binary dbname from users where
>dbname="brain" also returns both records.

SELECT dbname FROM users WHERE BINARY dbname = "brain"

perhaps?

>
>This surprises me.   Have I missed another option somewhere?
>
>
>Regards,
>Gary "SuperID" Huntress
>=======================================================
>FreeSQL.org offering free database hosting to developers
>Visit http://www.freesql.org

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