Hello.
In my opinion, this is not really a bug (however, I might be wrong - I don't speak danish :) O umlaut is an old writing of o with / through. See: http://users.cybercity.dk/~nmb3879/tree.html Probably latin1_danish_ci was designed to serve fields which contain only Danish symbols. If you have a look at section latin1_danish_ci in: /usr/share/mysql/characters/latin1.xml you will see the same numbers in different places - that means that different symbols are equal in this collation. If you want to properly handle extended set of characters use latin1_general_ci, or you may want to add your own collation. See: http://dev.mysql.com/doc/mysql/en/adding-character-set.html Jørgen Thomsen <[EMAIL PROTECTED]> wrote: >>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' > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]