To enable UTF-8 character encoding for Oracle databases in Genesys Administrator Extension releases 8.1.3 and higher, you must ensure that:
The database character set must be set to AL32UTF8 to support the use of UTF-8 character encoding. To verify the character set, use the following SQL command:
SELECT * FROM NLS_DATABASE_PARAMETERS;
In the response, if NLS_CHARACTERSET is set to AL32UTF8, no additional actions are required. Otherwise,
refer to the Oracle support guide for more information about character set migration:
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch11charsetmig.htm
Warning! Character-set migration is a non-reversible process. Incorrect data conversion can lead to data corruption, so always perform a full backup of the database before attempting to migrate the data to a new character set.
Note: In most cases, a full export and import is recommended to properly convert all data to a new character set.