>>>> 2012/01/16 19:57 -0800, Haluk Karamete >>>> MSSQL can be configured to work in either mode. Isn't such a thing for mySQL? For most of the time, I would not care about case-sensitivity. So I won't mind configuring the entire mysql operation to be case insensitive once and for all? <<<<<<<< In MySQL some operations, say, LIKE, have case-folding, and others (REPLACE) do not. Text-comparison also has case-folding. But there is also the attribute "BINARY": if a string is associated with that, there is no case-folding, whatever the operation. (One uses the function CONVERT to call a string binary, if that is needed.)
There is no mode associated with an instance of MySQL daemon, only with operations and character types. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql