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-1Locale 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-2Locale 8859-5Locale 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-7Locale 8859-8Locale 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-1Locale PC-Latin-2Locale 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 CP1250Locale CP1251Locale CP1252Locale 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 CP1254Locale CP1255Locale 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 big5Locale gbLocales 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 866Locale KOI-8Locale thai620

ru_ru.866

ru_ru.KOI-8          

th_th.thai620