My Oracle Support Banner

Multibyte Data Stored In the SJIS DB Gets Garbled with ORDS(Standalone) (Doc ID 2295202.1)

Last updated on JANUARY 30, 2018

Applies to:

Oracle REST Data Services - Version 3.0.9 and later
Information in this document applies to any platform.


Multibyte data stored in the database gets garbled when using ORDS(standalone), and calling a package that uses the OWA tookit. Below is an example of the test case:

 The package procedure was created as follows: 

CREATE OR REPLACE package MAS.ords_test as
procedure csv;
end ords_test;

htp.print('<Japanese character>');

Run the URL: http://hostname:XXXX/XXX/ords/ords_test.csv
Excel can be launched in Windows, but it is garbled.


 Migrated the mod_plsql application from mod_plsql(OHS) to ORDS(Standalone).


To view full details, 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 a vibrant support community of peers and Oracle experts.