>Description: Sorting order in latin1 broken >How-To-Repeat: Enter some strings into database and do select...order by
>Submitter-Id: <submitter ID> >Originator: Hadmut Danisch >MySQL support: none >Synopsis: Sorting order in latin1 broken >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.54 (Source distribution) >Environment: Linux, debian System: Linux sodom 2.4.20-universal-686 #1 Mit Dez 4 19:09:11 CET 2002 i686 unknown unknown GNU/Linux Architecture: i686 When querying text strings from a latin1 database, a text string starting with german "Ü" is ordered between "W" and "Y", but should be treated as "U" or "Ue". Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 2002-12-07 19:41 /lib/libc.so.6 -> libc-2.3.1.so -rwxr-xr-x 1 root root 1109068 2002-11-19 19:13 /lib/libc-2.3.1.so -rw-r--r-- 1 root root 2344038 2002-11-19 19:14 /usr/lib/libc.a -rw-r--r-- 1 root root 178 2002-11-19 19:14 /usr/lib/libc.so -rw-r--r-- 1 root root 726564 2002-06-16 07:53 /usr/lib/libc-client.so.2001 -rw-r--r-- 1 root root 742884 2002-11-01 21:42 /usr/lib/libc-client.so.2002 Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' '--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--without-docs' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' regards Hadmut --------------------------------------------------------------------- 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
