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
>>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: list@stripped
>>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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
