community.borland.com

Article #25664: 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                         



Last Modified: 23-OCT-00