Incorrect Characters In Database After Multi-byte Data Entry Using ORDS Deployed In Tomcat
Last updated on OCTOBER 27, 2016
Applies to:Oracle REST Data Services - Version 2.0.10 and later
Information in this document applies to any platform.
When entering text with diacritics or other multi-byte characters using APEX deployed on ORDS with Tomcat, the database contains incorrect characters.
Steps to Reproduce
* Start the application.
* Enter in a text field: Op ùs pleats
(The diacritic character has unicode code point 00F9 which is UTF-8 encoding hex value c3 b9)
* Select the record with SQL*Plus
It shows Op Ã¹s pleats instead of Op ùs pleats
If SqlPlus is used to update the record using UTF8 encoding it is correctly saved.
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