SAP Knowledge Base Article - Preview

3225327 - The function monthname(getdate()) cannot return Russian character

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

SAP IQ 16.0 ; SAP IQ 16.1

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.