PostgreSQL database based bug tracking and defect tracking
Apr 1, 2004 | Home > Bugzero > FAQs > KB

PostgreSQL database server character sets

The following table lists all the character sets that are available on PostgreSQL databases. The charset can be set on the database system level as well as on the JDBC URL. For the later, the format is:  jdbc:postgresql://localhost:5432/bugzero_db?charSet=UNICODE.

NameDescription
SQL_ASCIIASCII
EUC_JPJapanese EUC
EUC_CNChinese EUC
EUC_KRKorean EUC
JOHABKorean EUC (Hangle base)
EUC_TWTaiwan EUC
UNICODEUnicode (UTF-8)
MULE_INTERNALMule internal code
LATIN1ISO 8859-1/ECMA 94 (Latin alphabet no.1)
LATIN2ISO 8859-2/ECMA 94 (Latin alphabet no.2)
LATIN3ISO 8859-3/ECMA 94 (Latin alphabet no.3)
LATIN4ISO 8859-4/ECMA 94 (Latin alphabet no.4)
LATIN5ISO 8859-9/ECMA 128 (Latin alphabet no.5)
LATIN6ISO 8859-10/ECMA 144 (Latin alphabet no.6)
LATIN7ISO 8859-13 (Latin alphabet no.7)
LATIN8ISO 8859-14 (Latin alphabet no.8)
LATIN9ISO 8859-15 (Latin alphabet no.9)
LATIN10ISO 8859-16/ASRO SR 14111 (Latin alphabet no.10)
ISO_8859_5ISO 8859-5/ECMA 113 (Latin/Cyrillic)
ISO_8859_6ISO 8859-6/ECMA 114 (Latin/Arabic)
ISO_8859_7ISO 8859-7/ECMA 118 (Latin/Greek)
ISO_8859_8ISO 8859-8/ECMA 121 (Latin/Hebrew)
KOI8KOI8-R(U)
WINWindows CP1251
ALTWindows CP866
WIN1256Windows CP1256 (Arabic)
TCVNTCVN-5712/Windows CP1258 (Vietnamese)
WIN874Windows CP874 (Thai)

* Reference brought to you by Bugzero, it's more than just bug tracking software!