Posted by Richard Lynch on 05/04/05 03:09

On Mon, May 2, 2005 12:22 pm, Ross said:
> Had a look at it and much easier to use LIKE with wildcards. Was unsure
> whether the query was case sensitive that is why I asked.
>
> As it turns out it is not.

Actually, last time I checked, this was a COMPILE option to MySQL to be
case sensitive or not in = and LIKE.

The default is case insensitive.

It may also be configurable in /etc/my.cnf, but I don't think it was back
when I dug into this, way back when.

You'd have to actually read MySQL documentation or ask on a MySQL list to
get a definitive answer.

--
Like Music?
http://l-i-e.com/artists.htm

• Next in forum: Re: [PHP] php4 to php5, now classes don't work?
• Prev in forum: Re: [PHP] setting condition problem
• Thread view: Re: [PHP] just going with LIKE

[Reply to this message]