InterBase Character Sets and Collation Orders

From InterBase

Go Up to Character Sets and Collation Orders


The following table lists each character set that can be used in InterBase. For each character set, the minimum and maximum number of bytes used to store each character is listed, and all collation orders supported for that character set are also listed. The first collation order for a given character set is that default collation of the set, the one that is used if no COLLATE clause specifies an alternative order.

Character sets and collation orders
Character
set
Char.
set ID
Max.
char. size
Min.
char. size
Collation orders

ASCII

2

1 byte

1 byte

ASCII

BIG_5

56

2 bytes

1 byte

BIG_5

CYRL

50

1 byte

1 byte

CYRL

DB_RUS

PDOX_CYRL

DOS437

10

1 byte

1 byte

DOS437

DB_DEU437

DB_ESP437

DB_FIN437

DB_FRA437

DB_ITA437

DB_NLD437

DB_SVE437

DB_UK437

DB_US437

PDOX_ASCII

PDOX_INTL

PDOX_SWEDFIN

DOS850

11

1 byte

1 byte

DOS850

DB_DEU850

DB_ESP850

DB_FRA850

DB_FRC850

DB_ITA850

DB_NLD850

DB_PTB850

DB_SVE850

DB_UK850

DB_US850

DOS852

45

1 byte

1 byte

DOS852

DB_CSY

DB_PLK

DB_SLO

PDOX_CSY

PDOX_HUN

PDOX_PLK

PDOX_SLO

DOS857

46

1 byte

1 byte

DOS857

DB_TRK

DOS860

13

1 byte

1 byte

DOS860

DB_PTG860

DOS861

47

1 byte

1 byte

DOS861

PDOX_ISL

DOS863

14

1 byte

1 byte

DOS863

DB_FRC863

DOS865

12

1 byte

1 byte

DOS865

DB_DAN865

DB_NOR865

PDOX_NORDAN4

EUCJ_0208

6

2 bytes

1 byte

EUJC_0208

GB_2312

57

2 bytes

1 byte

GB_2312

ISO8859_1

21

1 byte

1 byte

ISO8859_1

CC_ESPLAT1

CC_PTBRLAT1

DA_DA

DE_DE

DU_NL

EN_UK

EN_US

ES_ES

FI_FI

FR_CA

FR_FR

IS_IS

IT_IT

NO_NO

PT_PT

SV_SV

ISO8859_2

22

1 byte

1 byte

ISO8859_2

CS_CZ

PL_PL

ISO8859_15

39

1 byte

1 byte

ISO8859_15

DA_DA9

DE_DE9

DU_NL9

EN_UK9

EN_US9

ES_ES9

FI_FI9

FR_CA9

FR_FR9

IS_IS9

IT_IT9

NO_NO9

PT_PT9

SV_SV9

KO18R

58

1 byte

1 byte

RU_RU

KSC_5601

44

2 bytes

1 byte

KSC_5601

KSC_DICTIONARY

NEXT

19

1 byte

1 byte

NEXT

NXT_DEU

NXT_FRA

NXT_ITA

NXT_US

NONE

0

1 byte

1 byte

NONE

OCTETS

1

1 byte

1 byte

OCTETS

SJIS_0208

5

2 bytes

1 byte

SJIS_0208

UNICODE_BE
UCS2BE

8

2 bytes

2 bytes

N/A at this time

UNICODE_FSS

3

3 bytes

1 byte

UNICODE_FSS

UNICODE_LE
UCS2LE

64

2 byte

2 bytes

N/A

UTF_8

59

4 byte

1 bytes

N/A at this time.

WIN1250

51

1 byte

1 byte

WIN1250

PXW_CSY

PXW_HUNDC

PXW_PLK

PXW_SLOV

WIN1251

52

1 byte

1 byte

WIN1251

PXW_CYRL

WIN1252

53

1 byte

1 byte

WIN1252

PXW_INTL

PXW_INTL850

PXW_NORDAN4

PXW_SPAN

PXW_SWEDFIN

WIN1253

54

1 byte

1 byte

WIN1253

PXW_GREEK

WIN1254

55

1 byte

1 byte

WIN1254

PXW_TURK

Topics

Advance To: