FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 Plugin tablesLicense notice 
Table 1. Character Sets and Collations
Character Set ID Bytes per Char Collation Language

ASCII

2

1

ASCII

English

BIG_5

56

2

BIG_5

Chinese, Vietnamese, Korean

CP943C

68

2

CP943C

Japanese

  {ditto}

{ditto}

{ditto}

CP943C_UNICODE

Japanese

CYRL

50

1

CYRL

Russian

  {ditto}

{ditto}

{ditto}

DB_RUS

Russian dBase

  {ditto}

{ditto}

{ditto}

PDOX_CYRL

Russian Paradox

DOS437

10

1

DOS437

U.S. English

  {ditto}

{ditto}

{ditto}

DB_DEU437

German dBase

  {ditto}

{ditto}

{ditto}

DB_ESP437

Spanish dBase

  {ditto}

{ditto}

{ditto}

DB_FIN437

Finnish dBase

  {ditto}

{ditto}

{ditto}

DB_FRA437

French dBase

  {ditto}

{ditto}

{ditto}

DB_ITA437

Italian dBase

  {ditto}

{ditto}

{ditto}

DB_NLD437

Dutch dBase

  {ditto}

{ditto}

{ditto}

DB_SVE437

Swedish dBase

  {ditto}

{ditto}

{ditto}

DB_UK437

English (Great Britain) dBase

  {ditto}

{ditto}

{ditto}

DB_US437

U.S. English dBase

  {ditto}

{ditto}

{ditto}

PDOX_ASCII

Code page Paradox-ASCII

  {ditto}

{ditto}

{ditto}

PDOX_INTL

International English Paradox

  {ditto}

{ditto}

{ditto}

PDOX_SWEDFIN

Swedish / Finnish Paradox

DOS737

9

1

DOS737

Greek

DOS775

15

1

DOS775

Baltic

DOS850

11

1

DOS850

Latin I (no Euro symbol)

  {ditto}

{ditto}

{ditto}

DB_DEU850

German

  {ditto}

{ditto}

{ditto}

DB_ESP850

Spanish

  {ditto}

{ditto}

{ditto}

DB_FRA850

French

  {ditto}

{ditto}

{ditto}

DB_FRC850

French-Canada

  {ditto}

{ditto}

{ditto}

DB_ITA850

Italian

  {ditto}

{ditto}

{ditto}

DB_NLD850

Dutch

  {ditto}

{ditto}

{ditto}

DB_PTB850

Portuguese-Brazil

  {ditto}

{ditto}

{ditto}

DB_SVE850

Swedish

  {ditto}

{ditto}

{ditto}

DB_UK850

English-Great Britain

  {ditto}

{ditto}

{ditto}

DB_US850

U.S. English

DOS852

45

1

DOS852

Latin II

  {ditto}

{ditto}

{ditto}

DB_CSY

Czech dBase

  {ditto}

{ditto}

{ditto}

DB_PLK

Polish dBase

  {ditto}

{ditto}

{ditto}

DB_SLO

Slovene dBase

  {ditto}

{ditto}

{ditto}

PDOX_CSY

Czech Paradox

  {ditto}

{ditto}

{ditto}

PDOX_HUN

Hungarian Paradox

  {ditto}

{ditto}

{ditto}

PDOX_PLK

Polish Paradox

  {ditto}

{ditto}

{ditto}

PDOX_SLO

Slovene Paradox

DOS857

46

1

DOS857

Turkish

  {ditto}

{ditto}

{ditto}

DB_TRK

Turkish dBase

DOS858

16

1

DOS858

Latin I (with Euro symbol)

DOS860

13

1

DOS860

Portuguese

  {ditto}

{ditto}

{ditto}

DB_PTG860

Portuguese dBase

DOS861

47

1

DOS861

Icelandic

  {ditto}

{ditto}

{ditto}

PDOX_ISL

Icelandic Paradox

DOS862

17

1

DOS862

Hebrew

DOS863

14

1

DOS863

French-Canada

  {ditto}

{ditto}

{ditto}

DB_FRC863

French dBase-Canada

DOS864

18

1

DOS864

Arabic

DOS865

12

1

DOS865

Scandinavian

  {ditto}

{ditto}

{ditto}

DB_DAN865

Danish dBase

  {ditto}

{ditto}

{ditto}

DB_NOR865

Norwegian dBase

  {ditto}

{ditto}

{ditto}

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

  {ditto}

{ditto}

{ditto}

GB18030_UNICODE

Chinese

GBK

67

2

GBK

Chinese

  {ditto}

{ditto}

{ditto}

GBK_UNICODE

Chinese

GB_2312

57

2

GB_2312

Simplified Chinese (Hong Kong, Korea)

ISO8859_1

21

1

ISO8859_1

Latin I

  {ditto}

{ditto}

{ditto}

DA_DA

Danish

  {ditto}

{ditto}

{ditto}

DE_DE

German

  {ditto}

{ditto}

{ditto}

DU_NL

Dutch

  {ditto}

{ditto}

{ditto}

EN_UK

English-Great Britain

  {ditto}

{ditto}

{ditto}

EN_US

U.S. English

  {ditto}

{ditto}

{ditto}

ES_ES

Spanish

  {ditto}

{ditto}

{ditto}

ES_ES_CI_AI

Spanish — case insensitive and + accent-insensitive

  {ditto}

{ditto}

{ditto}

FI_FI

Finnish

  {ditto}

{ditto}

{ditto}

FR_CA

French-Canada

  {ditto}

{ditto}

{ditto}

FR_CA_CI_AI

French-Canada — case insensitive + accent insensitive

  {ditto}

{ditto}

{ditto}

FR_FR

French

  {ditto}

{ditto}

{ditto}

FR_FR_CI_AI

French — case insensitive + accent insensitive

  {ditto}

{ditto}

{ditto}

IS_IS

Icelandic

  {ditto}

{ditto}

{ditto}

IT_IT

Italian

  {ditto}

{ditto}

{ditto}

NO_NO

Norwegian

  {ditto}

{ditto}

{ditto}

PT_BR

Portuguese-Brazil

  {ditto}

{ditto}

{ditto}

PT_PT

Portuguese

  {ditto}

{ditto}

{ditto}

SV_SV

Swedish

ISO8859_2

22

1

ISO8859_2

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

  {ditto}

{ditto}

{ditto}

CS_CZ

Czech

  {ditto}

{ditto}

{ditto}

ISO_HUN

Hungarian — case insensitive, accent sensitive

  {ditto}

{ditto}

{ditto}

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

  {ditto}

{ditto}

{ditto}

LT_LT

Lithuanian

KOI8R

63

1

KOI8R

Russian — dictionary ordering

  {ditto}

{ditto}

{ditto}

KOI8R_RU

Russian

KOI8U

64

1

KOI8U

Ukrainian — dictionary ordering

  {ditto}

{ditto}

{ditto}

KOI8U_UA

Ukrainian

KSC_5601

44

2

KSC_5601

Korean

  {ditto}

{ditto}

{ditto}

KSC_DICTIONARY

Korean — dictionary sort order

NEXT

19

1

NEXT

Coding NeXTSTEP

  {ditto}

{ditto}

{ditto}

NXT_DEU

German

  {ditto}

{ditto}

{ditto}

NXT_ESP

Spanish

  {ditto}

{ditto}

{ditto}

NXT_FRA

French

  {ditto}

{ditto}

{ditto}

NXT_ITA

Italian

  {ditto}

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

  {ditto}

{ditto}

{ditto}

TIS620_UNICODE

Thai

UNICODE_FSS

3

3

UNICODE_FSS

All English

UTF8

4

4

UTF8

Any language that is supported in Unicode 4.0

  {ditto}

{ditto}

{ditto}

UCS_BASIC

Any language that is supported in Unicode 4.0

  {ditto}

{ditto}

{ditto}

UNICODE

Any language that is supported in Unicode 4.0

  {ditto}

{ditto}

{ditto}

UNICODE_CI

Any language that is supported in Unicode 4.0 — Case insensitive

  {ditto}

{ditto}

{ditto}

UNICODE_CI_AI

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

WIN1250

51

1

WIN1250

ANSI — Central Europe

  {ditto}

{ditto}

{ditto}

BS_BA

Bosnian

  {ditto}

{ditto}

{ditto}

PXW_CSY

Czech

  {ditto}

{ditto}

{ditto}

PXW_HUN

Hungarian — case insensitive, accent sensitive

  {ditto}

{ditto}

{ditto}

PXW_HUNDC

Hungarian — dictionary ordering

  {ditto}

{ditto}

{ditto}

PXW_PLK

Polish

  {ditto}

{ditto}

{ditto}

PXW_SLOV

Slovenian

  {ditto}

{ditto}

{ditto}

WIN_CZ

Czech

  {ditto}

{ditto}

{ditto}

WIN_CZ_CI_AI

Czech — Case insensitive and accent insensitive

WIN1251

52

1

WIN1251

ANSI Cyrillic

  {ditto}

{ditto}

{ditto}

PXW_CYRL

Paradox Cyrillic (Russian)

  {ditto}

{ditto}

{ditto}

WIN1251_UA

Ukrainian

WIN1252

53

1

WIN1252

ANSI — Latin I

  {ditto}

{ditto}

{ditto}

PXW_INTL

English International

  {ditto}

{ditto}

{ditto}

PXW_INTL850

Paradox multilingual Latin I

  {ditto}

{ditto}

{ditto}

PXW_NORDAN4

Norwegian and Danish

  {ditto}

{ditto}

{ditto}

PXW_SPAN

Paradox Spanish

  {ditto}

{ditto}

{ditto}

PXW_SWEDFIN

Swedish and Finnish

  {ditto}

{ditto}

{ditto}

WIN_PTBR

Portuguese — Brazil

WIN1253

54

1

WIN1253

ANSI Greek

  {ditto}

{ditto}

{ditto}

PXW_GREEK

Paradox Greek

WIN1254

55

1

WIN1254

ANSI Turkish

  {ditto}

{ditto}

{ditto}

PXW_TURK

Paradox Turkish

WIN1255

58

1

WIN1255

ANSI Hebrew

WIN1256

59

1

WIN1256

ANSI Arabic

WIN1257

60

1

WIN1257

ANSI Baltic

  {ditto}

{ditto}

{ditto}

WIN1257_EE

Estonian — Dictionary ordering

  {ditto}

{ditto}

{ditto}

WIN1257_LT

Lithuanian — Dictionary ordering

  {ditto}

{ditto}

{ditto}

WIN1257_LV

Latvian — Dictionary ordering

WIN1258

65

1

WIN1258

Vietnamese