Appendix A. Multibyte Encoding Types
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 |
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.