Re: pg_client_encoding - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: pg_client_encoding
Date
Msg-id 20011012112232L.t-ishii@sra.co.jp
Whole thread Raw
In response to pg_client_encoding  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: pg_client_encoding
List pgsql-hackers
> Tatsuo,
> 
> Did you ever commit this new function?  I just tried a 'select 
> pg_client_encoding()' and it told me that there was no such function. 
> This was on sources that I pulled and built two days ago.
> 
> I was planning on changing the JDBC code to use this function instead of 
> getdatabaseencoding().

Sorry for the delay. I have just added pg_client_encoding() which
returns client side encoding name.

> Also, what names will this new function return (the old character set 
> names like getdatabaseencoding still does, or the new names)?

The "old" ones. To make sure, here are the encoding names list
currently supported. 

encoding    what pg_client_encoding/    alias    getdatabaseencoding    returns
----------------------------------------------------------------
ASCII        SQL_ASCII
UTF-8        UNICODE                UTF_8
MULE-INTERNAL    MULE_INTERNAL
ISO-8859-1    LATIN1                ISO_8859_1
ISO-8859-2    LATIN2                ISO_8859_2
ISO-8859-3    LATIN3                ISO_8859_3
ISO-8859-4    LATIN4                ISO_8859_4
ISO-8859-5    ISO_8859_5
ISO-8859-6    ISO_8859_6
ISO-8859-7    ISO_8859_7
ISO-8859-8    ISO_8859_8
ISO-8859-9    LATIN5                ISO_8859_9
ISO-8859-10    ISO_8859_10            LATIN6
ISO-8859-13    ISO_8859_13            LATIN7
ISO-8859-14    ISO_8859_14            LATIN8
ISO-8859-15    ISO_8859_15            LATIN9
ISO-8859-16    ISO_8859_16
EUC-JP        EUC_JP
EUC-CN        EUC_CN
EUC-KR        EUC_KR
EUC-TW        EUC_TW
Shift_JIS    SJIS                SHIFT_JIS
Big5        BIG5
Windows1250    WIN1250
Windows1251    WIN
KOI8-R        KOI8                KOI8R
IBM866        ALT

> thanks,
> --Barry
> 
> 
> 
> Tatsuo Ishii wrote:
> 
> > Hi,
> > 
> > I'm going to add a new function "pg_client_encoding" returning the
> > current client side encoding name. I know there is a similar
> > functionality already there in PostgreSQL (show client_encoding) but
> > it's pain to handle notice message by a program.
> > 
> > Also note that JDBC driver and maybe some other APIs use
> > getdatabaseencoding, but I think it's not adequate for FE APIs to know
> > actual encoding passed to FE side, since an encoding conversion might
> > be made in BE side. For example, if PGCLIENTENCODING is set to SJIS
> > before starting postmaster, the actual encoding passed to FE would be
> > SJIS even the database encoding is EUC_JP.
> > 
> > Comments?
> > --
> > Tatsuo Ishii
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> > 
> > 
> 
> 


pgsql-hackers by date:

Previous
From: Rachit Siamwalla
Date:
Subject: Re: Deadlock? idle in transaction
Next
From: Peter Eisentraut
Date:
Subject: Re: EXTRACT broken