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
