Database Utilities (MOSC)

MOSC Banner

NLS_LANG parameter issue

edited Feb 12, 2018 11:19PM in Database Utilities (MOSC) 9 commentsAnswered

Hi While testing some Ukraine characters nls parameter is not working for the session,Kindly help us on this,

select ('vidyaVIDYA') from dual;

select ('1234567890!@#$%^&*()_+') from dual;

select ('й') from dual;

select * from v$nls_parameters where parameter IN ('NLS_TERRITORY','NLS_LANGUAGE','NLS_CHARACTERSET');

ALTER SESSION SET NLS_LANGUAGE='UKRAINIAN';

--ALTER SESSION SET NLS_LANG='UKRAINIAN_UKRAINE.CL8MSWIN1251';

select ('vidyaVIDYA') from dual;

select ('1234567890!@#$%^&*()_+') from dual;

select ('й') from dual;

select * from v$nls_parameters where parameter ='NLS_LANGUAGE';

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Error starting at line 135 in command:

ALTER SESSION SET NLS_LANG = 'UKRAINIAN_UKRAINE.CL8MSWIN1251'

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