Symptom
The function monthname(getdate()) cannot return Russian character but Chinese is ok.
eoscodsap02:~ # export SALANG=RU
eoscodsap02:~ # export IQLANG=RU
eoscodsap02:~ # export LANG=ru_RU
eoscodsap02:~ # dbisql -c "..." -nogui
(eos)> select top 5 full_name from eos.users
full_name
--------------------------------
Алехина София --> Russian character shows correctly.
Волкова Анна
Давыдова Вероника
Дорофеев Денис
Козырев Марк
(5 rows)
(eos)> select monthname(getdate()) from iq_dummy;
monthname(getdate())
--------------------
July --> Cannot return Russian characters, but English instead.
(1 rows)
(eos)> exit
eoscodsap02:~ # export IQLANG=ZH
eoscodsap02:~ # export SALANG=ZH
eoscodsap02:~ # dbisql -c "..." -nogui
(eos)> select monthname(getdate()) from iq_dummy;
monthname(getdate())
--------------------
七月 --> Chinese returned.
(1 行)
Read more...
Environment
SAP IQ 16.1
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview