https://apex.oracle.com/pls/apex/f?p=57688:30
MS Word uses 8-bit accented characters for single and double quotes so when static text is copied from Microsoft Word documents and pasted into APEX regions, the text displays fine. But when the application is exported (both using the APEX UI as well as as the APEXExport Java class), these characters are not handled properly so when the application is imported into another environment, they are replaced by ???
But I am not sure I have fully diagnosed the issue. Exporting the application from Database 1 into Database 2 worked fine (preserved the MS Word quotes) but exporting the same application (SQL file) into Database 3 mangled the quotes. All 3 databases have UTF-8 character set.
Does the runtime environment of the import come into the picture here? Database 2 had the (Unix) environment variable NLS_LANG set to AMERICAN_AMERICA.AL32UTF8 while Database 3 probably doesn't have it set. Would that matter?
The SQL file itself also seems to replace the single/double quotes with weird characters but importing this file with NLS_LANG set to AMERICAN_AMERICA.AL32UTF8 renders them correctly in APEX. Since the export file is generated by the APEX engine, I was expecting it to contain the correct 8-bit character glyph
p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
'Single ‘ quote ',
'Double “ quote',
Not sure what's going on. Any ideas?