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.

Symptoms

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;
/

begin
owa_util.mime_header('application/excel-csv',true,'UTF-8');
htp.print('<Japanese character>');
end;
END ORDS_TEST;
/


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

Changes

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

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