[GENERAL] tsearch2, locale, UTF-8 and Windows

[Pierre Thibaudeau]

Over the past few days, I have been reading everything I could about
tsearch2, but I cannot figure out what the latest status is concerning the
default locale on a Windows UTF-8 database under PostgreSQL 8.2.

More specifically, 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...
I am at a loss concerning the locale with which I should initdb on my
system!!!

What am I getting myself into?  A lot of what I read on this matter was
pretty bleak;  has version 8.2 cleared all that?  What is the latest word on
this?

Re: [GENERAL] tsearch2, locale, UTF-8 and Windows

[Pierre Thibaudeau]

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, [EMAIL PROTECTED] (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...