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

Last updated on MARCH 09, 2023

Applies to:

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>:8080/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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.