Hi,
The document suggests that the string functions INSTR and LOCATE
are case-insensitive. However it does not seem to be so.
Did I interpret your documentation wrongly?
I tested the below on a few different versions of MySQL-3.23 on linux (rpm),
all with the same results.
Best Regards
Eric Koh
------------------------------------------
How-To-Repeat:
mysql> select instr('foobarbar', 'bar');
+---------------------------+
| instr('foobarbar', 'bar') |
+---------------------------+
| 4 |
+---------------------------+
mysql> select instr('foobarbar', 'Bar');
+---------------------------+
| instr('foobarbar', 'Bar') |
+---------------------------+
| 0 |
+---------------------------+
mysql> select instr('Foobarbar', 'foo');
+---------------------------+
| locate('bar','foobarbar') |
+---------------------------+
| 0 |
+---------------------------+
3 messages in com.mysql.lists.bugsfunctions INSTR & LOCATE (case sensit...
