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