>Description:
The letter 'ö' (o umlaut) and Danish 'ø' are treated as equal causing
duplicate key problems. They are not !
Check also 'ä' and 'æ' which are not equal.
It was present in 4.1.8 and is present in 4.1.14.
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator: [EMAIL PROTECTED]
>Organization:
>MySQL support: none
>Synopsis: Incorrect latin1_danish_ci collation
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.14-standard (MySQL Community Edition - Standard (GPL))
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.41 Distrib 4.1.14, 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.1.14-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 18 min 15 sec
Threads: 2 Questions: 3352395 Slow queries: 4 Opens: 40754 Flush tables: 1
Open tables: 18 Queries per second avg: 714.035
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux vennely.jth.net 2.6.12-1.1372_FC3 #1 Fri Jul 15 00:59:10 EDT 2005
i686 athlon i386 GNU/Linux
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/i386-redhat-linux/3.4.4/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posi\
x --disable-checking --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-java-awt=gtk --host=i386-redh\
at-linux
Thread model: posix
gcc version 3.4.4 20050721 (Red Hat 3.4.4-2)
Compilation info: CC='ccache gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='ccache
gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-construc\
tors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Apr 20 23:50 /lib/libc.so.6 -> libc-2.3.5.so
-rwxr-xr-x 1 root root 1505808 Apr 7 12:58 /lib/libc-2.3.5.so
-rw-r--r-- 1 root root 2409956 Apr 7 12:03 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 Apr 7 11:29 /usr/lib/libc.so
-rw-r--r-- 1 root root 204 Apr 7 11:29 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/b\
in' '--with-comment=MySQL Community Edition - Standard (GPL)'
'--with-extra-charsets=complex' '--with-server-suffix=-standard' '--e\
nable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--disable-shared' '--with-client-ldflags=-all-static' '--wi\
th-mysqld-ldflags=-all-static' '--with-raid' '--with-readline'
'--with-embedded-server' '--with-archive-storage-engine' '--with-inn\
odb' 'CC=ccache gcc' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CPPFLAGS=-DDEFAULT_THREAD_STACK=126976' 'CXXFLAGS=-O2 -mcpu=pentiumpro
-felide-\
constructors' 'CXX=ccache gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
