Documentation
Firebird default head
Sourceforge CCA Awards 2009

Documentation

Here we begin the project to build a centralized, linked index of Firebird/InterBase documentation to put what you need literally at your fingertips.

Firebird Documentation Project

This Firebird subproject aims to provide you with high-quality documentation for Firebird. If you are interested in our documentation developments, visit the Documentation Subproject pages in the Developer's corner.

Firebird License Conditions

InterBase® was released by Inprise under InterBase Public Licence. New Firebird® modules are released under the Initial Developer's Public License. Both are variants of the Mozilla Public Licence V.1.1 (MPL).

Firebird Project documentation is released under the Public Documentation License unless stated otherwise.

Firebird 1.5

Character Sets & Collations

Back

ID

Name

Bytes per Char

Collation

Language

Aliases

2

ASCII

1

ASCII

English

ASCII7, USASCII

56

BIG_5

2

BIG_5

Chinese, Vietnamese, Korean

BIG5, DOS_950, WIN_950

50

CYRL

1

CYRL

Russian

--

50

--

--

DB_RUS

Dbase Russian

--

50

--

--

PDOX_CYRL

Paradox Russian

--

10

DOS437

1

DOS437

English—USA

DOS_437

10

--

--

DB_DEU437

DBase German

--

10

--

--

DB_ESP437

DBase Spanish

--

10

--

--

DB_FRA437

DBase French

--

10

--

--

DB_FIN437

DBase Finnish

--

10

--

--

DB_ITA437

DBase Italian

--

10

--

--

DB_NLD437

DBase Dutch

--

10

--

--

DB_SVE437

DBase Swedish

--

10

--

--

DB_UK437

DBase English—UK

--

10

--

--

DB_US437

DBase English—USA

--

10

--

--

PDOX_ASCII

Paradox ASCII code page

--

10

--

--

PDOX_SWEDFIN

Paradox Swedish/Finnish code pages

--

10

--

--

PDOX_INTL

Paradox International English code page

--

9

DOS737

1

DOS737

Greek

DOS_737

15

DOS775

1

DOS775

Baltic

DOS_775

11

DOS850

1

DOS850

Latin I (no Euro symbol)

DOS_850

11

--

--

DB_DEU850

German

--

11

--

--

DB_ESP850

Spanish

--

11

--

--

DB_FRA850

French

--

11

--

--

DB_FRC850

French—Canada

--

11

--

--

DB_ITA850

Italian

--

11

--

--

DB_NLD850

Dutch

--

11

--

--

DB_PTB850

Portuguese—Brazil

--

11

--

--

DB_SVE850

Swedish

--

11

--

--

DB_UK850

English—UK

--

11

--

--

DB_US850

English—USA

--

45

DOS852

1

DOS852

Latin II

DOS_852

45

--

--

DB_CSY

DBase Czech

--

45

--

--

DB_PLK

DBase Polish

--

45

--

--

DB_SLO

DBase Slovakian

--

45

--

--

PDOX_PLK

Paradox Polish

--

45

--

--

PDOX_HUN

Paradox Hungarian

--

45

--

--

PDOX_SLO

Paradox Slovakian

--

45

--

--

PDOX_CSY

Paradox Czech

--

46

DOS857

1

DOS857

Turkish

DOS_857

46

--

--

DB_TRK

DBase Turkish

--

16

DOS858

1

DOS858

Latin I + Euro symbol

DOS_858

13

DOS860

1

DOS860

Portuguese

DOS_860

13

--

--

DB_PTG860

DBase Portuguese

--

47

DOS861

1

DOS861

Icelandic

DOS_861

47

--

--

PDOX_ISL

Paradox Icelandic

--

17

DOS862

1

DOS862

Hebrew

DOS_862

14

DOS863

1

DOS863

French—Canada

DOS_863

14

--

--

DB_FRC863

DBase French—Canada

--

18

DOS864

1

DOS864

Arabic

DOS_864

12

DOS865

1

DOS865

Nordic

DOS_865

12

--

--

DB_DAN865

DBase Danish

--

12

--

--

DB_NOR865

DBase Norwegian

--

12

--

--

PDOX_NORDAN4

Paradox Norwegian & Danish

--

48

DOS866

1

DOS866

Russian

DOS_866

49

DOS869

1

DOS869

Modern Greek

DOS_869

6

EUCJ_0208

2

EUCJ_0208

EUC Japanese

EUCJ

57

GB_2312

2

GB_2312

Simplified Chinese (Hong Kong, PRC)

DOS_936, GB2312, WIN_936

21

ISO8859_1

1

ISO8859_1

Latin 1

ANSI, ISO88591, LATIN1

21

--

--

FR_CA

French—Canada

--

21

--

--

DA_DA

Danish

--

21

--

--

DE_DE

German

--

21

--

--

ES_ES

Spanish

--

21

--

--

FI_FI

Finnish

--

21

--

--

FR_FR

French

--

21

--

--

IS_IS

Icelandic

--

21

--

--

IT_IT

Italian

--

21

--

--

NO_NO

Norwegian

--

21

--

--

DU_NL

Dutch

--

21

--

--

PT_PT

Portuguese

--

21

--

--

SV_SV

Swedish

--

21

--

--

EN_UK

English—UK

--

21

--

--

EN_US

English—USA

--

22

ISO8859_2

1

ISO8859_2

Latin 2—Central European (Croatian, Czech, Hungarian, Polish, Romanian, Serbian, Slovakian, Slovenian)

ISO-8859-2, ISO88592, LATIN2

22

--

--

CS_CZ

Czech

--

22

--

--

ISO_HUN

Hungarian

--

23

ISO8859_3

1

ISO8859_3

Latin3—Southern European (Maltese, Esperanto)

ISO-8859-3, ISO88593, LATIN3

34

ISO8859_4

1

ISO8859_4

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

ISO-8859-4, ISO88594, LATIN4

35

ISO8859_5

1

ISO8859_5

Cyrillic (Russian)

ISO-8859-5, ISO88595

36

ISO8859_6

1

ISO8859_6

Arabic

ISO-8859-6, ISO88596

37

ISO8859_7

1

ISO8859_7

Greek

ISO-8859-7, ISO88597

38

ISO8859_8

1

ISO8859_8

Hebrew

ISO-8859-8, ISO88598

39

ISO8859_9

1

ISO8859_9

Latin 5

ISO-8859-9, ISO88599, LATIN5

40

ISO8859_13

1

ISO8859_13

Latin 7—Baltic Rim

ISO-8859-13, ISO885913, LATIN7

44

KSC_5601

2

KSC_5601

Korean (Unified Hangeul)

DOS_949, KSC5601, WIN_949

44

--

--

KSC_DICTIONARY

Korean—dictionary order collation

--

19

NEXT

1

NEXT

NeXTSTEP encoding

--

19

--

--

NXT_US

English—USA

--

19

--

--

NXT_FRA

French

--

19

--

--

NXT_ITA

Italian

--

19

--

--

NXT_ESP

Spanish

--

19

--

--

NXT_DEU

German

--

0

NONE

1

NONE

Codepage-neutral. Uppercasing limited to ASCII codes 97—122

--

1

OCTETS

1

OCTETS

Binary character

BINARY

5

SJIS_0208

2

SJIS_0208

Japanese

SJIS

3

UNICODE_FSS

3

UNICODE_FSS

UNICODE

SQL_TEXT, UTF-8, UTF8, UTF_FSS

51

WIN1250

1

WIN1250

ANSI—Central European

WIN_1250

51

--

--

PXW_PLK

Polish

--

51

--

--

PXW_HUN

Hungarian

--

51

--

--

PXW_CSY

Czech

--

51

--

--

PXW_HUNDC

Hungarian—dictionary sort

--

51

--

--

PXW_SLOV

Slovakian

--

52

WIN1251

1

WIN1251

ANSI--Cyrillic

WIN_1251

52

--

--

WIN1251_UA

Ukrainian

--

52

--

--

PXW_CYRL

Paradox Cyrillic (Russian)

--

53

WIN1252

1

WIN1252

ANSI—Latin I

WIN_1252

53

--

--

PXW_SWEDFIN

Swedish & Finnish

--

53

--

--

PXW_NORDAN4

Norwegian & Danish

--

53

--

--

PXW_INTL

English—International

--

53

--

--

PXW_INTL850

Paradox Multi-lingual Latin I

--

53

--

--

PXW_SPAN

Paradox Spanish

--

54

WIN1253

1

WIN1253

ANSI Greek

WIN_1253

54

--

--

PXW_GREEK

Paradox Greek

--

55

WIN1254

1

WIN1254

ANSI Turkish

WIN_1254

55

--

--

PXW_TURK

Paradox Turkish

--

58

WIN1255

1

WIN1255

ANSI Hebrew

WIN_1255

59

WIN1256

1

WIN1256

ANSI Arabic

WIN_1256

60

WIN1257

1

WIN1257

ANSI Baltic

WIN_1257

Back

Get Firebird at SourceForge.net. Fast, secure and Free Open Source software downloads This site and the pages contained within are Copyright © 2000-2010, Firebird Project.
Firebird® is a registered trademark of Firebird Foundation Incorporated.