How to Send ISO-8859-1 Data to a User's Web Browser via MOD_PLSQL/OWA (Doc ID 1265065.1)

Last updated on JULY 06, 2023

Applies to:

Goal

There is a Web application built using the OWA toolkit in a UTF-8 database.

Most of the pages are sent in UTF-8 format but in a few situations data needs to be sent in ISO-8859-1.

Using the CONVERT function to convert data to the desired character set works relatively well, but if the last character in a string being written is not US ASCII then that character will be lost.

The objective is to send ISO-8859-1 data to a user's Web browser (more specifically, in CSV or SLK format for Excel) via mod_plsql/owa.

Solution

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