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...
