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