Re: Encoding-related errors when moving from 7.3 to 8.0.1 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Encoding-related errors when moving from 7.3 to 8.0.1
Date
Msg-id 20050323034415.GB7702@dcc.uchile.cl
Whole thread Raw
In response to Re: Encoding-related errors when moving from 7.3 to 8.0.1  (Carlos Moreno <moreno@mochima.com>)
List pgsql-general
On Tue, Mar 22, 2005 at 09:28:17PM -0500, Carlos Moreno wrote:

> >I guess what changed from version 7.4.x to 8.0 is that the default
> >server_encoding changed?
>
> Some further digging through the documentation reveals (in addition
> to the fact that I seem to be an incompetent when it comes to search
> through documentation :-)) that the above is indeed the case.

Oh, I forgot that.  In 8.0 the encoding is actually derived from the
locale settings, in case the platforms supports that.  Previously,
SQL_ASCII was always the default IIRC.

> Apparently, conversion from latin1 to UNICODE works?  (or at least
> doesn't trigger an error -- I wonder if some characters appear now
> incorrectly?  I'll check that).

Yes, it works (both ways).

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El realista sabe lo que quiere; el idealista quiere lo que sabe" (Anónimo)

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Question about function body checking and 8.1
Next
From: Tom Lane
Date:
Subject: Re: checkpoint_timeout