Re: upgrading to 8.3, utf-8 and latin2 locale problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mage <mage(at)mage(dot)hu>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: upgrading to 8.3, utf-8 and latin2 locale problem
Date: 2008-04-01 18:15:51
Message-ID: 11924.1207073751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mage <mage(at)mage(dot)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

In response to

Responses

Browse pgsql-general by date

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