List:General Discussion« Previous MessageNext Message »
From:(Hal Date:January 18 2012 1:49am
Subject:Re: case insensitivity
View as plain text  
>>>> 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.

case insensitivityHaluk Karamete17 Jan
  • Re: case insensitivityWilly Mularto17 Jan
    • Re: case insensitivityHaluk Karamete17 Jan
      • Re: case insensitivityhsv18 Jan
  • Re: case insensitivityDan Nelson17 Jan