Java™ is Unicode
based, so HCL OneDB™ JDBC
Driver converts
data between Unicode and the HCL
OneDB database
code set. The code-set conversion value is extracted from the DB_LOCALE value
specified at the time the connection is made. If the DB_LOCALE value
is incorrect, a Database Locale information mismatch error
occurs.
The
DB_LOCALE value must be a valid
HCL
OneDB locale,
with a valid
HCL
OneDB code-set
name or number as shown in the compatibility table that follows.
The following table maps the
supported Java development kit
encodings to HCL
OneDB code
sets.
HCL
OneDB code
set name |
HCL
OneDB code
set number |
JDK code set |
8859-1 |
819 |
8859_1 |
8859-2 |
912 |
8859_2 |
8859-3 |
57346 |
8859_3 |
8859-4 |
57347 |
8859_4 |
8859-5 |
915 |
8859_5 |
8859-6 |
1089 |
8859_6 |
8859-7 |
813 |
8859_7 |
8859-8 |
916 |
8859_8 |
8859-9 |
920 |
8859_9 |
8859-13 |
57390 |
ISO8859_13 |
ASCII |
364 |
ASCII |
sjis-s |
932 |
SJIS |
sjis |
57350 |
SJIS |
utf8 |
57372 |
UTF8 |
big5 |
57352 |
Big5 |
CP1250 |
1250 |
Cp1250 |
CP1251 |
1251 |
Cp1251 |
CP1252 |
1252 |
Cp1252 |
CP1253 |
1253 |
Cp1253 |
CP1254 |
1254 |
Cp1254 |
CP1255 |
1255 |
Cp1255 |
CP1256 |
1256 |
Cp1256 |
CP1257 |
1257 |
Cp1257 |
cp936 |
57357 |
ISO2022CN_GB |
cp_949 |
57356 |
Cp949 |
GB18030-2000 |
5488 |
GB18030 |
KS5601 |
57356 |
Cp949 |
ksc |
57356 |
Cp949 |
gb |
57357 |
ISO2022CN_GB |
GB2312-80 |
57357 |
ISO2022CN_GB |
GB18030-2000 |
5488 |
GB18030 |
ujis |
57351 |
EUC_JP |
HCL
OneDB code
set name |
HCL
OneDB code
set number |
JDK code set |
8859-1 |
819 |
8859_1 |
GB18030-2000 |
5488 |
GB18030 |
You cannot use the HCL
OneDB locale with a
code set for which there is no JDK-supported encoding. This incorrect usage results in an
Encoding or code set not supported error message.
The
following table shows the supported locales.
Supported Locales |
ar_ae |
ar_bh |
ar_kw |
ar_om |
ar_qa |
ar_sa |
bg_bg |
ca_es |
cs_cz |
da_dk |
de_at |
de_ch |
de_de |
el_gr |
en_au |
en_ca |
en_gb |
en_ie |
en_nz |
en_us |
es_ar |
es_bo |
es_cl |
es_co |
es_cr |
es_ec |
es_es |
es_gt |
es_mx |
es_pa |
es_pe |
es_py |
es_sv |
es_uy |
es_ve |
et_ee |
fi_fi |
fr_be |
fr_ca |
fr_ch |
fr_fr |
hr_hr |
hu_hu |
is_is |
it_ch |
it_it |
iw_il |
ja_jp |
ko_kr |
mk_mk |
nl_be |
nl_nl |
no_no |
pl_pl |
pt_br |
pt_pt |
ro_ro |
ru_ru |
sh_yu |
sk_sk |
sv_se |
th_th |
tr_tr |
uk_ua |
zh_cn |
zh_tw |
|
|
|
|
The supported locales are en_us and zh_cn.