Re: UTF8 conversion differences from v8.1.3 to v8.1.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: UTF8 conversion differences from v8.1.3 to v8.1.4
Date
Msg-id 1702.1153208129@sss.pgh.pa.us
Whole thread Raw
In response to UTF8 conversion differences from v8.1.3 to v8.1.4  (Eric Faulhaber <ecf@goldencode.com>)
Responses Re: UTF8 conversion differences from v8.1.3 to v8.1.4  (Eric Faulhaber <ecf@goldencode.com>)
List pgsql-general
Eric Faulhaber <ecf@goldencode.com> writes:
> Can anyone help me understand why converting the NULL code point (0000)
> from UTF8 to ISO8859_1 is no longer legal in v8.1.4?

Embedded nulls in text strings have never behaved sanely in PG ... or
hadn't you noticed?  You'd have been better off passing an empty string,
because that was effectively what you were getting.

            regards, tom lane

pgsql-general by date:

Previous
From: Eric Faulhaber
Date:
Subject: UTF8 conversion differences from v8.1.3 to v8.1.4
Next
From: Adem HUR
Date:
Subject: PostgreSQL on Embeded Systems