Table A-1 lists the various multibyte encoding types supported by PostgreSQL, as of version 7.1.x. These encoding types are only available if PostgreSQL was configured with the --enable-multibyte flag (see Chapter 2). A database can be created with a default encoding type if SQL_ASCII is not desired.
Table A-1. Multibyte Encoding Types
Encoding Type | Integer | Description |
---|---|---|
SQL_ASCII | 0 | Plain ASCII format |
EUC_JP | 1 | Japanese Extended UNIX Code |
EUC_CN | 2 | Chinese Extended UNIX Code |
EUC_KR | 3 | Korean Extended UNIX Code |
EUC_TW | 4 | Taiwan Extended UNIX Code |
UNICODE | 5 | UTF-8 Unicode |
MULE_INTERNAL | 6 | Mule internal type |
LATIN1 | 7 | ISO 8859-1 (English, with some European languages) |
LATIN2 | 8 | ISO 8859-2 (English, with some European languages) |
LATIN3 | 9 | ISO 8859-3 (English, with some European languages) |
LATIN4 | 10 | ISO 8859-4 (English, with some European languages) |
LATIN5 | 11 | ISO 8859-5 (English, with some European languages) |
KOI8 | 12 | KOI8-R |
WIN | 13 | Windows CP1251 |
ALT | 14 | Windows CP866 |