On Tue, Mar 06, 2001 at 11:48:16AM +0100, Ingo Herz wrote:
> Hi,
>
> I'm playing with Phils Linklist (midhoo 2). The resulting list is quite
> long (about 400 entries/articles), lot of them containing umlauts - some
> even beginning with one of these dirty characters. The problem: German
> umlauts are sorted regarding to their ASCII-Code, not in the order they
> have to...
>
> I think this is an important topic and the problem will occure in a lot
> of countries. Perhaps it could be a first step to substitute the existing
> sort routine with an international version.
Midgard doesn't sort anything by itself. It is MySQL who returns data
sorted in such order and solution really below that domain.
Look into MySQL manual for default_character_set option. It sets default
character set which will be used for storing data and for search/sorting
operations. Use it in my.cnf like this:
[client]
default-character-set = german1
to allow sorting according german rules and Latin-1 character set.
--
Sincerely yours, Alexander Bokovoy
The Midgard Project | www.midgard-project.org | Aurora R&D team
Minsk Linux Users Group | www.minsk-lug.net | www.aurora-linux.com
ALT Linux Team | www.alt-linux.org | Architecte Open Source
-- Just remember, wherever you go, there you are.
-- Buckaroo Bonzai
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
