[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    Re: functions INSTR & LOCATE (case sensitivity)
From:       Sergei Golubchik <serg () mysql ! com>
Date:       2002-06-10 11:56:53
[Download RAW message or body]

Hi!

On Jun 10, Michael Widenius wrote:
> 
> Hi!
> 
> >>>>> "Eric" == Eric Koh <erickoh@jobsfactory.com> writes:
> 
> Eric> Hi,
> Eric> The document suggests that the string functions INSTR and LOCATE
> Eric> are case-insensitive. However it does not seem to be so.
> Eric> Did I interpret your documentation wrongly?
> 
> Eric> I tested the below on a few different versions of MySQL-3.23 on linux (rpm),
> Eric> all with the same results.
> 
> From the manual regarding instr():
> 
> --------
> This function is multi-byte safe.  In MySQL 3.23 this function is case
> insensitive, while in 4.0 it's only case-insensitive if either argument is
> a binary string.
> ----------

Sorry - it's a bug in the manual.
It should say "case sensitive" instead of "case insensitive", of course.

We have fixed that, thanks for spotting the typo.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail bugs-thread12093@lists.mysql.com
To unsubscribe, e-mail <bugs-unsubscribe@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]