Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit : > Hi, > > When I execute a query in MySQL client, it seems like I cannot get the > case-sensitivity to be activated. > > If I ask: > SELECT * FROM mytable WHERE field = 'd'; > > I get all records containing 'd' or 'D'. > > How do I enable case-sensitivity?
OK sorry, I found that using 'binary' solves the problem. SELECT * FROM mytable WHERE field = binary 'd'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]