[All]
What character sets and collations does InterBase 5 support?
Abstract: What character sets and collations does InterBase 5 support?
Problem:
What character sets and collations does InterBase 5 support?
Solution:
InterBase 5 supports the Big5 character set and 24 other character
sets. Here's a list:
ASCII
BIG5
CYRL
DOS437
DOS850
DOS852
DOS857
DOS860
DOS861
DOS863
DOS865
EUCJ_0208
GB_2312
ISO8859_1
KSC_5601
NEXT
NONE
OCTETS (Binary)
SJIS_0208
UNICODE_FSS
WIN1250
WIN1251
WIN1252
WIN1253
WIN1254
select t1.rdb$character_set_name, t2.rdb$collation_name from
rdb$character_sets t1, rdb$collations t2
where t1.rdb$character_set_id = t2.rdb$character_set_id order by 1,2
RDB$CHARACTER_SET_NAME RDB$COLLATION_NAME
=============================== ===============================
ASCII ASCII
BIG_5 BIG_5
CYRL CYRL
CYRL DB_RUS
CYRL PDOX_CYRL
DOS437 DB_DEU437
DOS437 DB_ESP437
DOS437 DB_FIN437
DOS437 DB_FRA437
DOS437 DB_ITA437
DOS437 DB_NLD437
DOS437 DB_SVE437
DOS437 DB_UK437
DOS437 DB_US437
DOS437 DOS437
DOS437 PDOX_ASCII
DOS437 PDOX_INTL
DOS437 PDOX_SWEDFIN
DOS850 DB_DEU850
DOS850 DB_ESP850
DOS850 DB_FRA850
DOS850 DB_FRC850
DOS850 DB_ITA850
DOS850 DB_NLD850
DOS850 DB_PTB850
DOS850 DB_SVE850
DOS850 DB_UK850
DOS850 DB_US850
DOS850 DOS850
DOS852 DB_CSY
DOS852 DB_PLK
DOS852 DB_SLO
DOS852 DOS852
DOS852 PDOX_CSY
DOS852 PDOX_HUN
DOS852 PDOX_PLK
DOS852 PDOX_SLO
DOS857 DB_TRK
DOS857 DOS857
DOS860 DB_PTG860
DOS860 DOS860
DOS861 DOS861
DOS861 PDOX_ISL
DOS863 DB_FRC863
DOS863 DOS863
DOS865 DB_DAN865
DOS865 DB_NOR865
DOS865 DOS865
DOS865 PDOX_NORDAN4
EUCJ_0208 EUCJ_0208
GB_2312 GB_2312
ISO8859_1 DA_DA
ISO8859_1 DE_DE
ISO8859_1 DU_NL
ISO8859_1 EN_UK
ISO8859_1 EN_US
ISO8859_1 ES_ES
ISO8859_1 FI_FI
ISO8859_1 FR_CA
ISO8859_1 FR_FR
ISO8859_1 ISO8859_1
ISO8859_1 IS_IS
ISO8859_1 IT_IT
ISO8859_1 NO_NO
ISO8859_1 PT_PT
ISO8859_1 SV_SV
KSC_5601 KSC_5601
KSC_5601 KSC_DICTIONARY
NEXT NEXT
NEXT NXT_DEU
NEXT NXT_ESP
NEXT NXT_FRA
NEXT NXT_ITA
NEXT NXT_US
NONE NONE
OCTETS OCTETS
SJIS_0208 SJIS_0208
UNICODE_FSS UNICODE_FSS
WIN1250 PXW_CSY
WIN1250 PXW_HUNDC
WIN1250 PXW_PLK
WIN1250 PXW_SLOV
WIN1250 WIN1250
WIN1251 PXW_CYRL
WIN1251 WIN1251
WIN1252 PXW_INTL
WIN1252 PXW_INTL850
WIN1252 PXW_NORDAN4
WIN1252 PXW_SPAN
WIN1252 PXW_SWEDFIN
WIN1252 WIN1252
WIN1253 PXW_GREEK
WIN1253 WIN1253
WIN1254 PXW_TURK
WIN1254 WIN1254