Re: invalid byte sequence for encoding - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: invalid byte sequence for encoding
Date
Msg-id 1252907503.30236.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: invalid byte sequence for encoding  (Daniel Schuchardt <d.schuchardt@prodat-sql.de>)
List pgsql-general
On Mon, 2009-09-14 at 00:36 +0200, Daniel Schuchardt wrote:
> I know you are true with definition's and standards, however, that code
> works for about 6 years ;o)
>
> Well, we will change our parser behavoir. We will check out that
> standard_conforming_strings parameter too but i see a lot of problems
> with our backup and restore system (plain text pg_dump's) and other points.
>
> All in all will Postgres81 understand this E'' (\\0) escape chars too?
> Or do we have to make a several version for older Postgres versions?

What I don't understand about your issue is that '\0' should never have
worked in the first place.  You can expect it to work in the future, but
in old versions this should always have created a problem, either a
rejection or perhaps a truncated string.  So we're probably not seeing
the entire chain of processing here.



pgsql-general by date:

Previous
From: Marc Munro
Date:
Subject: Re: postgresql.key secure storage
Next
From: "Albe Laurenz"
Date:
Subject: Re: Getting Out Parameter in the application using libpq