[Zope] multiple languages - sorting

[Dieter Maurer]

Milos Prudek wrote at 2004-3-30 16:23 +0200:
>What is the best approach to support multiple human languages in Zope 
>with regards to sorting?
>
>- Use ZCatalog and ZODB? Is Zope still limited to one locale which it 
>read upon startup?

Sure, as "locale" uses static variables to maintain locale
information. Changing it would not be thread safe.

>- Put data into PostgreSQL? Unfortunately PostgreSQL uses system locale 
>to define sort order, and the locale is defined at the time of creation 
>of the whole database space. Basicaly it means one would have to run a 
>separate postgresql server for each supported language.
>
>- Use custom PostgreSQL function? The convert function (... using 
>utf_8_to_ascii) does not provide suitable data for sorting.

Define your own locale with a sort order that is acceptable by
all of your customers.
This task is non-trivial...

-- 
Dieter