How to set unicode

By ukmodak | March 31st 2024 10:32:28 AM | viewed 271 times

The following charecter exist in oracle

  • AL24UTFFSS
  • UTF8
  • UTFE
  • AL32UTF8 -- default
  • AL16UTF16

To set up UTF8 run the following command

c>sqlplus 
c>user-name:sys
c>password:sys
sql>show user
sql> select value from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET';
sql>SHUTDOWN IMMEDIATE;
sql>STARTUP RESTRICT;
sql>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
sql>ALTER SYSTEM DISABLE RESTRICTED SESSION;
SQL>ALTER DATABASE OPEN;
sql>select value from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET';
bONEandALL
Visitor

Total : 20364

Today :18

Today Visit Country :

  • United Kingdom
  • United States
  • China
  • Singapore
  • Russia
  • Czechia