change database character set


Step1. Check NLS_CHARACTERSET 
Connect to user SYS or SYSTEM

SELECT * 
FROM V$NLS_PARAMETERS 
WHERE PARAMETER = 'NLS_CHARACTERSET';

Parameter Value
NLS_CHARACTERSET AL32UTF8 
Change NLS_CHARACTERSET from AL32UTF8 to WE8ISO8859P1 

Step2. Connect to user SYS

Step3. Update value 

UPDATE PROPS$
SET VALUE$ = 'WE8ISO8859P1'
WHERE NAME = 'NLS_CHARACTERSET';

COMMIT; 

Step4. Restart database

SHUT IMMEDIATE;

STARTUP;

Step5. Check NLS_CHARACTERSET 
Connect to user SYS or SYSTEM

SELECT * FROM 
V$NLS_PARAMETERS 
WHERE PARAMETER = 'NLS_CHARACTERSET';

Parameter Value
NLS_CHARACTERSET WE8ISO8859P1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: