Wednesday 22 November 2023

CHARACTER SET in Database

A character set determines what languages can be represented in the database.

Oracle recommends Unicode AL32UTF8 as the database character set. Unicode is the universal character set that supports most of the currently spoken languages of the world.

SQL> select PARAMETER,VALUE from nls_database_parameters where PARAMETER like '%NLS_CHARACTERSET%';

PARAMETER                                VALUE
---------------------------------------- ----------------------------------------
NLS_CHARACTERSET                         AL32UTF8

In EBS application also we can find character set information in System Administrator--Oracle Applications Manager---SiteMap--System Configuration--License Manager--Languages