Supported locales

Informix® Warehouse Accelerator supports a subset of the locales that HCL Informix supports.

Some of the locales are not supported by the JDBC environment that is needed to run administrative commands for the accelerator. For these locales you must map the locale to a different locale or code set name, only for the connection through JDBC, for example in the Java™ connection URL. See User-defined locales for information about how to map the locale in the Java connection URL.

Locale 8859-1 and 8859-15

The following table lists the supported locales:
Table 1. Information for locales 8859-1 and 8859-15
Locale 8859-1 Locale 8859-15

da_dk.8859-1
de_at.8859-1
de_at.8859-1@bun1
de_at.8859-1@bund
de_at.8859-1@dud1
de_at.8859-1@dude
de_ch.8859-1
de_ch.8859-1@bun1
de_ch.8859-1@bund
de_ch.8859-1@dude
de_de.8859-1
de_de.8859-1@bun1
de_de.8859-1@bund
de_de.8859-1@dud1
de_de.8859-1@dude
en_au.8859-1
en_gb.8859-1
en_us.8859-1
en_us.8859-1@dict
en_us.8859-1@dres
en_us.8859-1@extn
es_es.8859-1
es_es.8859-1@ra94
es_es.8859-1@rae
fi_fi.8859-1
fr_be.8859-1
fr_ca.8859-1
fr_ch.8859-1
fr_fr.8859-1
is_is.8859-1
it_it.8859-1
nl_be.8859-1
nl_nl.8859-1
no_no.8859-1
pt_br.8859-1
pt_pt.8859-1
sv_se.8859-1

da_dk.8859-15
de_at.8859-15
de_at.8859-15@bun1
de_at.8859-15@dud1
de_ch.8859-15
de_ch.8859-15@bun1
de_ch.8859-15@dud1
de_de.8859-15
de_de.8859-15@bun1
de_de.8859-15@dud1
en_gb.8859-15
en_us.8859-15
en_us.8859-15@dict
es_es.8859-15
es_es.8859-15@rae
fi_fi.8859-15
fr_be.8859-15
fr_ch.8859-15
fr_fr.8859-15
it_it.8859-15
nl_be.8859-15
nl_nl.8859-15
no_no.8859-15
pt_pt.8859-15
sv_se.8859-15

Locales 8859-2, 8859-5, and 8859-6

The following table lists the supported locales:
Table 2. Information for locales 8859-2, 8859-5, and 8859-6
Locale 8859-2 Locale 8859-5 Locale 8859-6

cs_cz.8859-2
cs_cz.8859-2@sis
hr_hr.8859-2
hu_hu.8859-2
pl_pl.8859-2
ro_ro.8859-2
sh_hr.8859-2  
    (Needs mapping to
     hr_hr.8859-2
     for Java/JDBC)
sk_sk.8859-2
sk_sk.8859-2@sn

bg_bg.8859-5
ru_ru.8859-5
uk_ua.8859-5

The following locales are supported if mapped to the ar_ae.8859-6 locale for the Java/JDBC connection: ar_dz, ar_eg, ar_jo, ar_lb, ar_ma, ar_sy, ar_tn, and ar_ye.

ar_ae.8859-6
ar_ae.8859-6@greg
ar_ae.8859-6@isla
ar_bh.8859-6
ar_bh.8859-6@greg
ar_bh.8859-6@isla
ar_kw.8859-6
ar_kw.8859-6@greg
ar_kw.8859-6@isla
ar_om.8859-6
ar_om.8859-6@greg
ar_om.8859-6@isla
ar_qa.8859-6
ar_qa.8859-6@greg
ar_qa.8859-6@isla
ar_sa.8859-6
ar_sa.8859-6@greg
ar_sa.8859-6@isla
ar_dz.8859-6
ar_eg.8859-6
ar_jo.8859-6
ar_lb.8859-6
ar_ma.8859-6
ar_sy.8859-6
ar_tn.8859-6
ar_ye.8859-6

Locales 8859-7, 8859-8, and 8859-9

The following table lists the supported locales:
Table 3. Information for locales 8859-7, 8859-8, and 8859-9
Locale 8859-7 Locale 8859-8 Locale 8859-9

el_gr.8859-7

iw_il.8859-8
iw_il.8859-8@greg
iw_il.8859-8@hebr

tr_tr.8859-9@ifix

Locales utf-8

The following table lists the supported locales:
Table 4. Information for locales utf-8
Locale utf-8 (ar_ae - hu_hu) Locale utf8 (ja_jp - zh_tw)

ar_ae.utf8
ar_bh.utf8
ar_kw.utf8
ar_om.utf8
ar_qa.utf8
ar_sa.utf8
cs_cz.utf8
da_dk.utf8
de_at.utf8
de_ch.utf8
de_de.utf8
en_au.utf8
en_gb.utf8
en_us.utf8
es_es.utf8
fi_fi.utf8
fr_be.utf8
fr_ca.utf8
fr_ch.utf8
fr_fr.utf8
hr_hr.utf8
hu_hu.utf8

ja_jp.utf8
ko_kr.utf8
nl_be.utf8
nl_nl.utf8
no_no.utf8
pl_pl.utf8
pt_br.utf8
pt_pt.utf8
ro_ro.utf8
ru_ru.utf8
sh_hr.utf8  
    (Needs mapping to
     hr_hr.utf8
     for Java/JDBC)
sk_sk.utf8
sv_se.utf8
th_th.utf8
tr_tr.utf8  
tr_tr.utf8@ifix
zh_cn.utf8
zh_hk.utf8  
    (Needs mapping to
     zh_tw.utf8 for Java/JDBC)
zh_tw.utf8

Locales PC-Latin-1, PC-Latin-2, and 858

The PC-Latin codesets need to be replaced with the following codesets:
  • Replace PC-Latin-1 with 850
  • Replace PC-Latin-2 with 852
  • Replace PC-Latin-1 w_euro with 858

For the Java/JDBC connection, the codeset name 858 then needs to be mapped to Latin9.

Note: The sh_hr locale must be mapped to hr_hr for the Java/JDBC connection.
The following table lists the supported locales:
Table 5. Information for locales PC-Latin-1, PC-Latin-2, and 858
Locale PC-Latin-1 Locale PC-Latin-2 Locale 858

da_dk.PC-Latin-1  
de_at.PC-Latin-1  
de_at.PC-Latin-1@bund
de_at.PC-Latin-1@dude
de_ch.PC-Latin-1      
de_ch.PC-Latin-1@bund
de_ch.PC-Latin-1@dude
de_de.PC-Latin-1      
de_de.PC-Latin-1@bun1
de_de.PC-Latin-1@bund
de_de.PC-Latin-1@dud1
de_de.PC-Latin-1@dude
en_au.PC-Latin-1      
en_gb.PC-Latin-1      
en_us.PC-Latin-1      
en_us.PC-Latin-1@dict
es_es.PC-Latin-1      
es_es.PC-Latin-1@rae  
fi_fi.PC-Latin-1      
fr_be.PC-Latin-1      
fr_ca.PC-Latin-1      
fr_ch.PC-Latin-1      
fr_fr.PC-Latin-1      
is_is.PC-Latin-1      
it_it.PC-Latin-1      
nl_be.PC-Latin-1      
nl_nl.PC-Latin-1      
no_no.PC-Latin-1    
pt_pt.PC-Latin-1      
sv_se.PC-Latin-1    

cs_cz.PC-Latin-2
hr_hr.PC-Latin-2
hu_hu.PC-Latin-2
pl_pl.PC-Latin-2
ro_ro.PC-Latin-2
sh_hr.PC-Latin-2
sk_sk.PC-Latin-2

da_dk.858
de_at.858
de_at.858@bund
de_at.858@dude
de_de.858    
de_de.858@bun1
de_de.858@bund
de_de.858@dud1
de_de.858@dude
es_es.858    
fi_fi.858  
fr_be.858    
fr_fr.858  
it_it.858    
nl_be.858
nl_nl.858  
pt_pt.858

Locales CP1250, CP1251, CP1252, and CP1253

The following table lists the supported locales:
Table 6. Information for locales CP1250, CP1251, CP1252, and CP1253
Locale CP1250 Locale CP1251 Locale CP1252 Locale CP1252 (cont.) Locale CP1253

cs_cz.CP1250
hr_hr.CP1250
hu_hu.CP1250
pl_pl.CP1250
ro_ro.CP1250
sh_hr.CP1250  
    (Needs mapping to
     hr_hr.CP1250
     for Java/JDBC)
sk_sk.CP1250

bg_bg.1251
ru_ru.1251
uk_ua.1251

da_dk.CP1252
da_dk.CP1252@euro
de_at.CP1252
de_at.CP1252@bun1
de_at.CP1252@bund
de_at.CP1252@dud1
de_at.CP1252@dude
de_at.CP1252@ebu1
de_at.CP1252@edu1
de_at.CP1252@euro
de_ch.CP1252
de_ch.CP1252@bun1
de_ch.CP1252@bund
de_ch.CP1252@dud1
de_ch.CP1252@dude
de_ch.CP1252@ebu1
de_ch.CP1252@edu1
de_ch.CP1252@euro
de_de.CP1252
de_de.CP1252@bun1
de_de.CP1252@bund
de_de.CP1252@dud1
de_de.CP1252@dude
de_de.CP1252@ebu1
de_de.CP1252@edu1
de_de.CP1252@euro
en_au.CP1252
en_gb.CP1252
en_gb.CP1252@euro
en_us.CP1252

en_us.CP1252@dict
en_us.CP1252@edic
en_us.CP1252@euro
es_es.CP1252
es_es.CP1252@euro
es_es.CP1252@rae
fi_fi.CP1252
fi_fi.CP1252@euro
fr_be.CP1252
fr_be.CP1252@euro
fr_ca.CP1252
fr_ch.CP1252
fr_ch.CP1252@euro
fr_fr.CP1252
fr_fr.CP1252@euro
is_is.CP1252
it_it.CP1252
it_it.CP1252@euro
nl_be.CP1252
nl_be.CP1252@euro
nl_nl.CP1252
nl_nl.CP1252@euro
no_no.CP1252
no_no.CP1252@euro
pt_br.CP1252
pt_pt.CP1252
pt_pt.CP1252@euro
sv_se.CP1252
sv_se.CP1252@euro

el_gr.1253

Locales CP1254, CP1255, and CP1256

The following table lists the supported locales:
Table 7. Information for locales CP1254, CP1255, and CP1256
Locale CP1254 Locale CP1255 Locale CP1256

tr_tr.CP1254@ifix

iw_il.1255
iw_il.1255@greg
iw_il.1255@hebr

ar_ae.1256
ar_ae.1256@greg
ar_ae.1256@isla
ar_bh.1256
ar_bh.1256@greg
ar_bh.1256@isla
ar_kw.1256
ar_kw.1256@greg
ar_kw.1256@isla
ar_om.1256
ar_om.1256@greg
ar_om.1256@isla
ar_qa.1256
ar_qa.1256@greg
ar_qa.1256@isla
ar_sa.1256
ar_sa.1256@greg
ar_sa.1256@isla

Locales big5, gb, ksc, and cp949

The following table lists the supported locales:
Table 8. Information for locales big5, and gb
Locale big5 Locale gb Locales ksc and cp949

zh_cn.big5
zh_tw.big5
zh_hk.big5-HKSCS
   (needs to be mapped to
     zh_tw.Big5-HKSCS
    for  Java/JDBC
    connection)  

zh_cn.gb
zh_tw.gb

ko_kr.ksc
ko_kr.cp949
   (Needs mapping to
    ko_kr.windows-949
    for Java/JDBC
    connection)

Locales 866, KOI-8, and thai620

The following table lists the supported locales:
Table 9. Information for locales 866, KOI-8, thai620
Locale 866 Locale KOI-8 Locale thai620

ru_ru.866

ru_ru.KOI-8          

th_th.thai620                
Parent topic: Informix Warehouse Accelerator
Copyright© 2018 HCL Technologies Limited