Re: [HACKERS] pg_client_encoding

Hello all,

getdatabaseencoding returns available encodings in 7.2.

Jean-Michel

**********************************************
Copy from Hackers:

>
> 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