Special Characters (eg Å Ä Ö å ä ö) Are Shown Incorrectly When Passed as URL Parameters (Doc ID 1598422.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.1 and later
Information in this document applies to any platform.

Symptoms

NOTE : This issue only arises when Oracle Application Express (APEX) is installed in a Non-UTF8 Database. 

 

Special characters such as  Å Ä Ö å ä ö when passed as a URL parameter are not displayed correctly in it's corresponding APEX Item. It seems that is it 'double-escpaing' the values.
For example the string

"Höga Å_Ä_Ö_å_ä_ö"


is shown as 
 

"Höga Å_Ä_Ö_å_ä_ö"

 

 

Changes

APEX was upgraded to version 4.2.3. However, this can also occur in previous versions. 

Cause

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