>Description:
I was trying to find every row in a table which contains the umlaut
� (ue). MySQL listed every row which contained the umlaut and rows
which contained the letter y, but no umlaut... Client and server
characterset is latin1.
>How-To-Repeat:
CREATE TABLE test ( name VARCHAR(2) );
INSERT INTO test VALUES ( "a" );
INSERT INTO test VALUES ( "b" );
INSERT INTO test VALUES ( "�" );
INSERT INTO test VALUES ( "y" );
mysql> SELECT * FROM test WHERE name LIKE "%�%";
+------+
| name |
+------+
| � |
| y |
+------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM test WHERE name LIKE "%y%";
+------+
| name |
+------+
| � |
| y |
+------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM test WHERE name REGEXP ".*�.*";
+------+
| name |
+------+
| � |
+------+
1 row in set (0.00 sec)
>Fix:
One can workaround this bug by using REGEXP instead of LIKE. But
than you have to rewrite your queries...
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis:
>Severity non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.51, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.51-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 9 days 11 hours 18 min 1 sec
Threads: 5 Questions: 8261442 Slow queries: 19203 Opens: 2834 Flush tables: 867
Open tables: 64 Queries per second avg: 10.096
>Environment:
System: Linux cleopatra 2.2.19 #7 Sat Oct 6 02:37:48 CEST 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 4060896 Jan 17 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 19186278 Jan 17 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 17 2001 /usr/lib/libc.so
Configure command: ./configure --without-bench --prefix=/opt/mysql-3.23
--enable-assembler --with-tcp-port=3306 --with-raid --with-innodb --with-berkeley-db
Perl: This is perl, version 5.005_03 built for i586-linux
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
