Re: minor changes in psql's \encoding command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: minor changes in psql's \encoding command
Date: 2003-01-05 05:17:04
Message-ID: 6596.1041743824@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

I said:
> I'd prefer to just document that PQclientEncoding is untrustworthy if
> the client sets the encoding directly (rather than via PGCLIENTENCODING
> or PQsetClientEncoding), and similarly that psql's \encoding is not
> trustworthy if one goes behind its back.

On looking closer, both libpq and psql assume that their current
internal encoding settings accurately describe the strings they get
from the backend. So hacking up PQclientEncoding() wouldn't be enough
to fix all the problems anyway.

I think we need to document that doing "SET client_encoding" directly is
hazardous to your health with either of these interfaces, and perhaps
with others as well. Anyone know how JDBC and ODBC deal with encoding?

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-01-05 05:46:05 Re: minor changes in psql's \encoding command
Previous Message Weiping He 2003-01-05 05:13:38 Re: minor changes in psql's \encoding command