Re: Very strange Error in Updates - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Very strange Error in Updates
Date
Msg-id 40F71EB2.9080304@opencloud.com
Whole thread Raw
In response to Re: Very strange Error in Updates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very strange Error in Updates - Worst than ever !
List pgsql-jdbc
Tom Lane wrote:
> Oliver Jowett <oliver@opencloud.com> writes:
>
>>What about refusing to change client_encoding to something other than
>>SQL_ASCII on SQL_ASCII databases?
>
>
> Not sure that would do anything very useful.  People who aren't thinking
> about this probably aren't thinking about setting client_encoding
> properly, either.

I was thinking about it from the other angle -- clients that set
client_encoding and expect the server to do the conversion (e.g. the
JDBC driver) will see an error rather than bogus unconverted data.

What does the server currently do if you ask for a client_encoding that
isn't supported by the database encoding (e.g. LATIN1<->LATIN2)? It
seems to me that SQL_ASCII is kinda-sorta-if-you-squint-a-bit like an
encoding that doesn't support any client_encoding but SQL_ASCII.

-O

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Very strange Error in Updates
Next
From: "Dario V. Fassi"
Date:
Subject: Re: Very strange Error in Updates - Worst than ever !