Re: tsearch2, locale, UTF-8 and Windows

Just to pinpoint the meaning of my dismay, let me add one comment to my
previous post.

In the What'sNew document for tsearch2 with 8.2
http://www.sai.msu.su/~megera/wiki/Tsearch2WhatsNew
we read:

> Don't forget to initdb cluster with correct utf8-locale !
> initdb -D /usr/local/pgsql-dev/data.el_utf8 --locale=el_GR.utf8

I have never seen any detail of what was meant by the "correct" locale.
Clearly if I was using a database with French content on a French system, I
would intuitively choose fr_FR.utf8 as the locale, but if my database
contains texts in several languages (see quoted post below), I don't know on
what factor to base my choice of initdb locale.

Suggestions?

On Jan 28, 3:28 am, pierd(dot)(dot)(dot)(at)gmail(dot)com ("Pierre Thibaudeau") wrote:
> [...] I cannot figure out what the latest status is concerning the
> "default locale" on a Windows UTF-8 database under PostgreSQL 8.2.
>
> [...] I have a UTF-8 database containing information in five
> different European languages (English, French, Spanish, German and
> Italian). I am coding on a Windows system with locale French_Canada.1252.
> The server that will soon run the database will likely have locale
en_US...