Re: ORDER BY and Unicode

> > And how can I do an initdb so that sorting on Unicode will work for
>> French, Greek, Japanase, etc. users of a single database?
>
>AFAIK, you can't really at this time. With an appropriately crafted
>locale, you could probably get reasonably close, but I've never actually
>tried to work with creating one so I don't know what's involved. And, if
>two languages had different rules for two characters you'd not be
>supporting both.

Thanks Stephan! I've found my list of locales. It's a pity only one
language can be used at a time but as you say there are conflicting
rules anyway.

The docs say there is a speed penalty on using locales. Does anyone
have any idea on how severe this is? I'm wondering wether I should
use the translate() function after all because of this. It would
solve multilingual issues to a certain level and there wouldn't be a
speed penalty since the indexes would be build on the translate()
function too.

Marc