[Zope] multiple languages - sorting

Milos Prudek prudek at bvx.cz
Tue Mar 30 09:23:14 EST 2004


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




More information about the Zope mailing list