Apex export error on 'special' characters (ie. ë and ©)
StefanHJan 8 2009 — edited Aug 11 2009When exporting an APEX application page containing special characters such as 'ë' or '©', these characters are not exported properly.
In the export file that is generated, the ë is displayed as 'ë' .
Problem must have something to do with nls settings in the database / application.
nls settings in the database american_america.WE8ISO8859P1
When exporting, I can specify things like 'application', 'file format' and 'export comments'. What I cannot specify is the 'file character set'. This setting is fixed as 'Unicode UTF-8'
Any suggestions on how I can prevent these errors / change the 'file character set'?