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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
