Differences

This shows you the differences between two versions of the page.

--- database:oracle:change-character-set [2019/03/24 23:46] – created odefta
+++ database:oracle:change-character-set [2019/03/24 23:51] – odefta
@@ Line 1: / Line 1: @@
-====== Change character set for a database ======
+====== Change character set (and national character set) for a database ======
 **sqlplus /nolog**
@@ Line 32: / Line 32: @@
 <code>
 System altered.
+</code>
+SQL> **select * from nls_database_parameters where parameter like '%SET%';**
+<code>
+PARAMETER                 VALUE
+------------------------- -------------------------
+NLS_NCHAR_CHARACTERSET    AL16UTF16
+NLS_CHARACTERSET          WE8ISO8859P15
 </code>