User Tools

Site Tools


database:oracle:change-character-set

Differences

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

Link to this comparison view

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