tsearch2, locale, UTF-8 and Windows

From: "Pierre Thibaudeau" <pierdeux(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tsearch2, locale, UTF-8 and Windows
Date: 2007-01-28 08:28:37
Message-ID: 74b035bb0701280028p5d4c4f77l6a5277e618b6fb91@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-01-28 10:04:45 Re: Predicted lifespan of different PostgreSQL branches
Previous Message Tom Lane 2007-01-28 03:24:07 Re: Limit on number of users in postgresql?