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.