Enabling UTF-8 Character Encoding (for Oracle)

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.