InterBase Character Sets

From InterBase
Jump to: navigation, search

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 symbol 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 implicit collation of the set, the one that is used if no COLLATE clause specifies an alternative order. The implicit collation order cannot be specified in the COLLATE clause.

Collation names of the form WINxxxx are defined by Microsoft, those of the form DB_xxx are dBASE, and those that start with PDOX or PXW are Paradox. Collation names of the form AA-BB are ISO collations: AA is the language, BB is the country.

Character sets and collation orders
Character set Character
set ID
Maximum
character size
Minimum
character 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_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

CC_PTBRLAT9

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

KOI8R

58

1 byte

1 byte

KOI8R

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_FSS

3

3 bytes

1 byte

UNICODE_FSS

UNICODE_BE
UCS2BE

8

2 bytes

2 bytes

N/A at this time

UNICODE_LE
UCS2LE

64

2 byte

2 bytes

N/A

UTF_8

59

4 bytes

1 byte

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

CC_PTBRWIN
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

Advance To: