Hello,
>Description:
A select returns uncomplete results, when querying an indexed
varchar row with latin1_de character set and strings containing umlauts
or 'ß'.
>How-To-Repeat:
start MySQL 4.0 with character set latin1_de.
create table test (word varchar(255) not null default '', index(word));
insert into test values ('ss'),('ß'),('ä'),('ae');
select * from test where word='ss';
+------+
| ss |
| ß |
+------+
-> looks fine.
select * from test where word='ß';
+------+
| ss |
+------+
select * from test where word='ä';
+------+
| ae |
+------+
-> is what you least expect.
To get even more confused, the result is changing:
select * from test where word like 'ae';
-- ae
select * from test where word='ä';
-- ae, ä
select * from test where word='ae';
-- ae, ä
select * from test where word='ä';
-- ae
>Fix:
Workaround:
- use german1, if you can live with 'a'='ä'
- use latin1, if you can live with the sorting order 'z'<'ä'
- use varchar binary , if you don't need case insensitive matching
What results does MySQL 4.1 produce?
Regards,
Fabian.
>MySQL support: none
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Server: /usr/local/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, 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 4.0.11-gamma-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 6 min 18 sec
Threads: 2 Questions: 18 Slow queries: 0 Opens: 13 Flush tables: 1
Open tables: 2 Queries per second avg: 0.048
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686
Architecture: i686
Some paths: /usr/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.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc'
CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS=''
ASFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1394302 Okt 2 10:06 /lib/libc.so.6
-rw-r--r-- 1 root root 25361748 Okt 2 09:36 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mär 23 2002 /usr/lib/libc.so
-rw-r--r-- 1 root root 869190 Mär 23 2002
/usr/lib/libc-client.a
lrwxrwxrwx 1 root root 20 Aug 29 2002
/usr/lib/libc-client.so -> libc-client.so.2001a
-rwxr-xr-x 1 root root 725296 Mär 23 2002
/usr/lib/libc-client.so.2001a
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-comment=Official MySQL-standard binary'
'--with-extra-charsets=complex' '--with-server-suffix=-standard'
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2
-mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors'
'CXX=gcc'
--
TextTech GmbH
Karl-Heine-Str. 99, 04229 Leipzig
Tel. 0341 / 4912 245
---------------------------------------------------------------------
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
