Documentation Center

Using accented characters on Linux

If working on a Linux system with an Oracle database, to enable accented characters when creating Property Sheets, Property Fields, Roles, Tool Boxes, and other Objects, the NLS_CHARACTERSET must be set to AL32UTF8.

Procedure

  1. Log in as user oracle.
  2. Shut down the Oracle instance.
  3. Start Oracle in the RESTRICT mode.
  4. Using SQLPlus, issue the following SQL command:
    ALTER DATABASE CHARACTER SET AL32UTF8
  5. Shut down Oracle.
  6. Start the Oracle instance in normal mode.
  7. Ensure that the NLS_CHARACTERSET is set to AL32UTF8 by issuing the SQL command (using SQLPlus):
    select name,substrb(value$,1,40) value from props$;