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 M
In the last episode (Jan 16), Haluk Karamete said:
> How do I do case insensitive searches and replace operations? Is there an
> easy way to do this? Like some sort of a server level setting telling
> mySQL to ignore case for once and for all?
For searches (i.e. comparisons in the WHERE clause),
Thank you for your reply... But isn't "like" very very slow in
comparison to a none-like straight search?
Isn't it an overkill for a case sensitivity issue?
It appears to me that like has its own usage arena and case
sensitivity issue won't just justify the use of it...
MSSQL can be configured to
use LIKE
On Jan 17, 2012, at 10:36 AM, Haluk Karamete wrote:
> How do I do case insensitive searches and replace operations?
> Is there an easy way to do this? Like some sort of a server level
> setting telling mySQL to ignore case for once and for all?
>
> --
> MySQL General Mailing List
> F
New "binary" character set should appear in next release.
It provides case-sensitive comparisons. It even doesn't
require recompiling mysqld, you need just to put binary.conf
file into /share directory of mysql installation, then restart
mysqld with "--default-character-set=binary" argument.
If yo
