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
- Log in as user oracle.
- Shut down the Oracle instance.
- Start Oracle in the RESTRICT mode.
- Using SQLPlus, issue the following SQL command:
ALTER DATABASE CHARACTER SET AL32UTF8
- Shut down Oracle.
- Start the Oracle instance in normal mode.
- 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$;