Case Insensitivity of queries and record lookup

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

An example (in mSQL):

SELECT * FROM custiebase WHERE my_id = "FOO001"\g
would return the record for FOO001.

SELECT * FROM custiebase WHERE my_id = "foo001"\g
would return that the record couldn't be found

Same example (in MySQL):

SELECT * FROM custiebase WHERE my_id = "FOO001";
would return the record for FOO001.

SELECT * FROM custiebase WHERE my_id = "foo001";
would return the record for FOO001.

=

Why is this?  Is there a way that I can return to the case-sensitive
behavior that had existed with my mSQL db with MySQL?

--
 Mark P. Hennessy                                             mark@xxxxxxxxxx


---------------------------------------------------------------------
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-thread113346@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php