At 15:58 06.03.01 +0200, you wrote:
>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.
yet tried, works like a charm! thanks to the best helpdesk I know...
regards,
Ingo
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
