Appendix HCharacter Sets and Collations

Table H.1Character Sets and Collations
Character SetIDBytes per CharCollationLanguage

ASCII

2

1

ASCII

English

BIG_5

56

2

BIG_5

Chinese, Vietnamese, Korean

CP943C

68

2

CP943C

Japanese

  〃

CP943C_UNICODE

Japanese

CYRL

50

1

CYRL

Russian

  〃

DB_RUS

Russian dBase

  〃

PDOX_CYRL

Russian Paradox

DOS437

10

1

DOS437

U.S. English

  〃

DB_DEU437

German dBase

  〃

DB_ESP437

Spanish dBase

  〃

DB_FIN437

Finnish dBase

  〃

DB_FRA437

French dBase

  〃

DB_ITA437

Italian dBase

  〃

DB_NLD437

Dutch dBase

  〃

DB_SVE437

Swedish dBase

  〃

DB_UK437

English (Great Britain) dBase

  〃

DB_US437

U.S. English dBase

  〃

PDOX_ASCII

Code page Paradox-ASCII

  〃

PDOX_INTL

International English Paradox

  〃

PDOX_SWEDFIN

Swedish / Finnish Paradox

DOS737

9

1

DOS737

Greek

DOS775

15

1

DOS775

Baltic

DOS850

11

1

DOS850

Latin I (no Euro symbol)

  〃

DB_DEU850

German

  〃

DB_ESP850

Spanish

  〃

DB_FRA850

French

  〃

DB_FRC850

French-Canada

  〃

DB_ITA850

Italian

  〃

DB_NLD850

Dutch

  〃

DB_PTB850

Portuguese-Brazil

  〃

DB_SVE850

Swedish

  〃

DB_UK850

English-Great Britain

  〃

DB_US850

U.S. English

DOS852

45

1

DOS852

Latin II

  〃

DB_CSY

Czech dBase

  〃

DB_PLK

Polish dBase

  〃

DB_SLO

Slovene dBase

  〃

PDOX_CSY

Czech Paradox

  〃

PDOX_HUN

Hungarian Paradox

  〃

PDOX_PLK

Polish Paradox

  〃

PDOX_SLO

Slovene Paradox

DOS857

46

1

DOS857

Turkish

  〃

DB_TRK

Turkish dBase

DOS858

16

1

DOS858

Latin I (with Euro symbol)

DOS860

13

1

DOS860

Portuguese

  〃

DB_PTG860

Portuguese dBase

DOS861

47

1

DOS861

Icelandic

  〃

PDOX_ISL

Icelandic Paradox

DOS862

17

1

DOS862

Hebrew

DOS863

14

1

DOS863

French-Canada

  〃

DB_FRC863

French dBase-Canada

DOS864

18

1

DOS864

Arabic

DOS865

12

1

DOS865

Scandinavian

  〃

DB_DAN865

Danish dBase

  〃

DB_NOR865

Norwegian dBase

  〃

PDOX_NORDAN4

Paradox Norway and Denmark

DOS866

48

1

DOS866

Russian

DOS869

49

1

DOS869

Modern Greek

EUCJ_0208

6

2

EUCJ_0208

Japanese EUC

GB18030

69

4

GB18030

Chinese

  〃

GB18030_UNICODE

Chinese

GBK

67

2

GBK

Chinese

  〃

GBK_UNICODE

Chinese

GB_2312

57

2

GB_2312

Simplified Chinese (Hong Kong, Korea)

ISO8859_1

21

1

ISO8859_1

Latin I

  〃

DA_DA

Danish

  〃

DE_DE

German

  〃

DU_NL

Dutch

  〃

EN_UK

English-Great Britain

  〃

EN_US

U.S. English

  〃

ES_ES

Spanish

  〃

ES_ES_CI_AI

Spanish — case insensitive and + accent-insensitive

  〃

FI_FI

Finnish

  〃

FR_CA

French-Canada

  〃

FR_CA_CI_AI

French-Canada — case insensitive + accent insensitive

  〃

FR_FR

French

  〃

FR_FR_CI_AI

French — case insensitive + accent insensitive

  〃

IS_IS

Icelandic

  〃

IT_IT

Italian

  〃

NO_NO

Norwegian

  〃

PT_BR

Portuguese-Brazil

  〃

PT_PT

Portuguese

  〃

SV_SV

Swedish

ISO8859_2

22

1

ISO8859_2

Latin 2 — Central Europe (Croatian, Czech, Hungarian, Polish, Romanian, Serbian, Slovak, Slovenian)

  〃

CS_CZ

Czech

  〃

ISO_HUN

Hungarian — case insensitive, accent sensitive

  〃

ISO_PLK

Polish

ISO8859_3

23

1

ISO8859_3

Latin 3 — Southern Europe (Malta, Esperanto)

ISO8859_4

34

1

ISO8859_4

Latin 4 — Northern Europe (Estonian, Latvian, Lithuanian, Greenlandic, Lappish)

ISO8859_5

35

1

ISO8859_5

Cyrillic (Russian)

ISO8859_6

36

1

ISO8859_6

Arabic

ISO8859_7

37

1

ISO8859_7

Greek

ISO8859_8

38

1

ISO8859_8

Hebrew

ISO8859_9

39

1

ISO8859_9

Latin 5

ISO8859_13

40

1

ISO8859_13

Latin 7 — Baltic

  〃

LT_LT

Lithuanian

KOI8R

63

1

KOI8R

Russian — dictionary ordering

  〃

KOI8R_RU

Russian

KOI8U

64

1

KOI8U

Ukrainian — dictionary ordering

  〃

KOI8U_UA

Ukrainian

KSC_5601

44

2

KSC_5601

Korean

  〃

KSC_DICTIONARY

Korean — dictionary sort order

NEXT

19

1

NEXT

Coding NeXTSTEP

  〃

NXT_DEU

German

  〃

NXT_ESP

Spanish

  〃

NXT_FRA

French

  〃

NXT_ITA

Italian

  〃

19

1

NXT_US

U.S. English

NONE

0

1

NONE

Neutral code page. Translation to upper case is performed only for code ASCII 97-122. Recommendation: avoid this character set

OCTETS

1

1

OCTETS

Binary character encoding

SJIS_0208

5

2

SJIS_0208

Japanese

TIS620

66

1

TIS620

Thai

  〃

TIS620_UNICODE

Thai

UNICODE_FSS

3

3

UNICODE_FSS

All English

UTF8

4

4

UTF8

Any language that is supported in Unicode 4.0

  〃

UCS_BASIC

Any language that is supported in Unicode 4.0

  〃

UNICODE

Any language that is supported in Unicode 4.0

  〃

UNICODE_CI

Any language that is supported in Unicode 4.0 — Case insensitive

  〃

UNICODE_CI_AI

Any language that is supported in Unicode 4.0 — Case insensitive and accent insensitive

WIN1250

51

1

WIN1250

ANSI — Central Europe

  〃

BS_BA

Bosnian

  〃

PXW_CSY

Czech

  〃

PXW_HUN

Hungarian — case insensitive, accent sensitive

  〃

PXW_HUNDC

Hungarian — dictionary ordering

  〃

PXW_PLK

Polish

  〃

PXW_SLOV

Slovenian

  〃

WIN_CZ

Czech

  〃

WIN_CZ_CI_AI

Czech — Case insensitive and accent insensitive

WIN1251

52

1

WIN1251

ANSI Cyrillic

  〃

PXW_CYRL

Paradox Cyrillic (Russian)

  〃

WIN1251_UA

Ukrainian

WIN1252

53

1

WIN1252

ANSI — Latin I

  〃

PXW_INTL

English International

  〃

PXW_INTL850

Paradox multilingual Latin I

  〃

PXW_NORDAN4

Norwegian and Danish

  〃

PXW_SPAN

Paradox Spanish

  〃

PXW_SWEDFIN

Swedish and Finnish

  〃

WIN_PTBR

Portuguese — Brazil

WIN1253

54

1

WIN1253

ANSI Greek

  〃

PXW_GREEK

Paradox Greek

WIN1254

55

1

WIN1254

ANSI Turkish

  〃

PXW_TURK

Paradox Turkish

WIN1255

58

1

WIN1255

ANSI Hebrew

WIN1256

59

1

WIN1256

ANSI Arabic

WIN1257

60

1

WIN1257

ANSI Baltic

  〃

WIN1257_EE

Estonian — Dictionary ordering

  〃

WIN1257_LT

Lithuanian — Dictionary ordering

  〃

WIN1257_LV

Latvian — Dictionary ordering

WIN1258

65

1

WIN1258

Vietnamese