after apex application export and import wrong umlaute
Hallo,
Has someone done an apex application export (e.g. f100.sql) from one instance and then imported it into anoter apex instance and got all umlaute (ÖÄÜöäüß) wrong in the titles, labels and other descriptive text.
I exported the application with the parameter "file format: UNIX" and File Character Set: Unicode UTF-8 .
What can I do to get the import with correct Umlaute?
I also exported the schema and the data from one instance to the other and they are correct.
Only the apex application umlaute are wrong.
Instance A is on UNIX:
Application Express 3.1.2.00.02
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
Character Set: WE8ISO8859p15
PlsqlNlsLanguage: GERMAN_GERMANY.AL32UTF8
HTTP Listener
Instance B is on Windows:
Oracle 10 XE
Character Set: WE8ISO8859P15
DAD: GERMAN_GERMANY.AL32UTF8
APEX: 3.1.2.00.02
Embedded PL/SQL Gateway
In my understanding it shouldn't matter from where I export the APEX application and where i import it.
Thx for every hint, Willi
P.S. The Embedded PL/SQL Gateway from the XE was changed the following way:
BEGIN
DBMS_EPG.set_dad_attribute (
dad_name => 'APEX',
attr_name => 'nls-language',
attr_value => 'GERMAN_GERMANY.AL32UTF8');
END;
/
alter database character set internal_use WE8ISO8859p15;
alter database character set WE8ISO8859p15;