How Set the Characterset When Using APEX_APPLICATION_INSTALL and SQL*Plus to Import an Application
Last updated on NOVEMBER 24, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 4.0.2.00.07 and later
Information in this document applies to any platform.
When doing an application import using the GUI APEX interface or through SQL Developer, the application characterset can be selected from a drop down list. However, when using SQL*Plus with the APEX_APPLICATION_INSTALL package to set the Workspace, User, etc, there is not an option to set the Character set.
How can you set / change the characterset when doing an APEX application import from SQL*Plus with the APEX_APPLICATION_INSTALL package in order to avoid wrong characters displayed in the imported application?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms