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 22.214.171.124 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
>FreeSQL.org offering free database hosting to developers