EPM 11.1.2 - Issues during configuration when using Oracle DB if not using UTF8
By Ahmed Awan on Jun 30, 2011
If you see issues during configuration when using Oracle DB if not using UTF8:
a. During configuration of EPM products, a warning message is displayed if the Oracle DB is not UTF8 enabled. If you continue with the configuration, certain products will not work as they will not be able to read the contents in the tables as the format is wrong.
b. The Oracle DB must be setup to use AL32UTF8 or a superset that contains AL32UTF8.
c. The only difference between AL32UTF8 and UTF8 character sets is that AL32UTF8 stores characters beyond U+FFFF as four bytes (exactly as Unicode defines UTF-8). Oracle’s “UTF8” stores these characters as a sequence of two UTF-16 surrogate characters encoded using UTF-8 (or six bytes per character). Besides this storage difference, another difference is better support for supplementary characters in AL32UTF8 character set.