Re: encoding of PostgreSQL messages - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: encoding of PostgreSQL messages
Date
Msg-id 49942406.1010608@tpf.co.jp
Whole thread Raw
In response to Re: encoding of PostgreSQL messages  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: encoding of PostgreSQL messages
List pgsql-general
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
>> Tom Lane wrote:
>>> Reflecting on the bigger picture ...  I would imagine that the vast
>>> majority of existing applications depend on client_encoding settings
>>> that come from postgresql.conf, ALTER USER SET, ALTER DATABASE SET, or
>>> just the default (== database encoding).  I don't think a solution that
>>> penalizes those cases and makes only

not only but also the JDBC driver or the ODBC driver sends the
startup packet including the client_encoding. Libpq can be changed
to allow *client_encoding=xxxxx* definition in conninfo.

> the case of setting it via
>>> PGCLIENTENCODING work nicely is going to make very many people happy.

Not a few libraries/applications issue SET client_encoding to ...
immediately after the connection was establised. What's wrong with
urging such clients to eliminate the SET commands and use the nice
feature of FE/BE procotol?

regards,
Hiroshi Inoue




pgsql-general by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Fwd: Need help in porting Oracle PL/SQL's OUT paramater based procedures
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Update table with random values from another table