Re: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING" - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"
Date
Msg-id 200012291900.OAA16219@candle.pha.pa.us
Whole thread Raw
In response to About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"  (Chih-Chang Hsieh <cch@cc.kmu.edu.tw>)
Responses Re: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
We have merged README.mb into the official SGML docs, so the file is
gone.  Not sure what setup we have for SGML docs in different languages.

Sorry.


---------------------------------------------------------------------------


Tatsuo Ishii  wrote:

> Here are the patches I promised against PHP
> 3.0.15 or later.
>
> To set the client encoding to BIG5:
>
> pg_setclientencoding($cid, "BIG5");
>
>   ($cid is the connection id)
>
> To get the current client encoding:
>
> pg_clientencoding($cid);
>
> Note that these fucntions are already included in the latest PHP4.

Thank you!
Your README.mb has been translate into Chinese (Big5 encoding) in the
attachement.
Would someone like to review it?
After translating it, I still have one question: (Sorry, I have not read the
source code.)
What is the difference among "libpq  -- PQsetClientEncoding()",
"SQL command  -- SET NAMES", and
"SQL command -- SET CLIENT_ENCODING"?
For example: If we use PHP (>4.0.2),  which way is correct or mostly correct?

1. pg_setclientencoding($cid, "BIG5")
2. pg_exec("SET NAMES 'BIG5'")
3. pg_exec("SET CLIENT_ENCODING TO 'BIG5'")

--
Chih-Chang Hsieh



--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Assuming that TAS() will succeed the first time is verboten
Next
From: sergiop@sinectis.com.ar
Date:
Subject: Notify with Rules bugs?