Database Administration (MOSC)

MOSC Banner

CHANGING characterset

edited Sep 22, 2011 8:23PM in Database Administration (MOSC) 6 commentsAnswered
Hi all,

I need to change the NLS_NCHAR_CHARACTERSET from AL16UTF16 to WE8ISO8859P1 in my new 11g database. Can you please show me the steps on how to do it. I cant find the documents on this.

Hope someone will be able to help me to change this

select PARAMETER||' '||VALUE from V$NLS_PARAMETERS where PARAMETER like '%CHARACTER%';

NLS_CHARACTERSET WE8ISO8859p1

NLS_NCHAR_CHARACTERSET AL16UTF16

Thanks

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