Insert/Retrieve Russian cyrillic characters in Oracle DB
Hi -
Russian characters are displayed as ????????.
[DEV] SYS> select value from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
AL32UTF8
[DEV] SYS> select value from NLS_DATABASE_PARAMETERS where parameter='NLS_LANGUAGE';
VALUE
--------------------------------------------------------------------------------
AMERICAN
[DEV] SYS> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
EMP_ID VARCHAR2(35 CHAR)
[DEV] SYS> insert into TEST values ('БГЖИЗЛФЦ');
1 row created.
[DEV] SYS> commit;
Commit complete.
[DEV] SYS> select * from test;
EMP_ID
-----------------------------------
????????????????
[DEV] SYS>
Can anyone suggest me how can i view the russian characters when I do select.
Thanks
Praveen