Re: upgrading to 8.3, utf-8 and latin2 locale problem - Mailing list pgsql-general

From Tom Lane
Subject Re: upgrading to 8.3, utf-8 and latin2 locale problem
Date
Msg-id 11924.1207073751@sss.pgh.pa.us
Whole thread Raw
In response to upgrading to 8.3, utf-8 and latin2 locale problem  (Mage <mage@mage.hu>)
Responses Re: upgrading to 8.3, utf-8 and latin2 locale problem  (Mage <mage@mage.hu>)
List pgsql-general
Mage <mage@mage.hu> writes:
> We would like to upgrade from 8.1 to 8.3. We have UTF-8 and LATIN2
> databases. Any idea?

If you were running with a non-C database locale, that was always
broken in 8.1, and you are very fortunate not to have stumbled across
any of the failure cases.

You can either standardize on UTF8 for all your databases (note that
this does not stop your *clients* from using LATIN2 if they want),
or use C locale which will work equally poorly with all encodings ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting weird pg_tblspc error, has anyone seen this before?
Next
From: Mage
Date:
Subject: Re: upgrading to 8.3, utf-8 and latin2 locale problem