Hi I have installed mysql 4.0 from source with
./configure \ --with-charset=latin1_de --with-extra-charsets=all Question 1: Is it true that the above does not make latin1_de my default character set for sorting? When I tried to set the default character set to latin1_de in /etc/my.cnf I got an error saying that the character set does not exist. As a matter of fact there was an entry in charsets/Index giving latin1_de number 31 but there was no latin1_de.conf in the directory charsets. Bug1: latin1_de.conf missing Bug2 (Documentation): the history for 4.0.0 mentions a character set "latin_de" instead of "latin1_de" Question 2: What does "correct German sorting" mean and what is the difference between charsets german1 and latin1_de Actually "correct german sorting" is far from being trivial and in computing usually approximations are used: One rule is: An umlaut character (diaeresis) has the same ordering value as its corresponding base character with the exception that if two words differ only by a diaeresis on a character the one with the diaeresis comes after the one without (this is still a little simplified). An example makes it clearer: bar Bär Bären Barenboim bärtig The character U+00DF (ß) is treated like two letters 's' but her it comes _before_ 'ss' if everything else is identical. Sincerely Matthias ------------------------------------------------------ Matthias Ragaz Informatik - Entwicklung Schweizerische Bibliothek für Blinde und Sehbehinderte Albisriederstasse 399 CH-8047 Zürich Schweiz Tel.: +41 1 491 25 55 Fax: +41 1 492 64 75 ------------------------------------------------------ --------------------------------------------------------------------- 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