Database Administration (MOSC)

MOSC Banner

Insert/Retrieve Russian cyrillic characters in Oracle DB

edited Oct 28, 2016 5:00AM in Database Administration (MOSC) 14 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center