How to Change Database Character Set

Posted on
Assuming that you have exported all the data to dump file for further process. Please shutdown the database.SQL> column parameter format a25;SQL> column value format a25;SQL> select parameter, value from v$nls_parameters where parameter like ‘%CHARACTERSET%’;PARAMETER                 VALUE————————- ————————-NLS_CHARACTERSET          ZHT16MSWIN950NLS_NCHAR_CHARACTERSET    AL16UTF16SQL> shutdown immediate;Database closed.Database […]
Initialization Parameter

How to Distinguish the Differences Between CHAR and BYTE – By Example

Posted on
Most of databases set NLS_LENGTH_SEMANTICS as BYTE, but there are some databases in Non-English country will take CHAR as the default unit of data type for CHAR and VARCHAR2.In other words, if there is no explicit unit in the columns definition during table creation, the unit of type CHAR and VARCHAR2 column will follow the default NLS_LENGTH_SEMANTICS.Let’s see an […]