Re: Case Insensitivity of queries and record lookup

On 28 Jun 2002, at 14:27, Mark Hennessy wrote:

> I have noticed after migrating my database from mSQL to MySQL that
> queries are providing lookup results in a case-insensitive manner.

To avoid that, make your CHAR and VARCHAR columns BINARY, or if you 
only want to make *some* comparisons case-sensitive, use BINARY in 
your query:

http://www.mysql.com/doc/C/H/CHAR.html
http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html

-- 
Keith C. Ivey <keith@xxxxxxxxxxx>
Tobacco Documents Online
http://tobaccodocuments.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 <mysql-thread113368@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php