30 Mar
2004
30 Mar
'04
2:23 p.m.
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? - 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. -- Milos Prudek