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.