Posts

Showing posts from September, 2014

change oracle database character set

change oracle database character set from WE8MSWIN1252 to AL32UTF8 and from AL32UTF8 to WE8ISO8859P1 :- [oracle@netmindtwcint ~]$ sqlplus sys/sys as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Wed Sep 24 17:10:31 2014 Copyright (c) 1982, 2010, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';  2    3 PARAMETER ---------------------------------------------------------------- VALUE ---------------------------------------------------------------- NLS_CHARACTERSET WE8MSWIN1252 SQL> UPDATE PROPS$ SET VALUE$ = 'AL32UTF8' WHERE NAME = 'NLS_CHARACTERSET';  2    3 1 row updated. SQL> COMMIT; Commit complete. SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. OR...