>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