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

Last updated on FEBRUARY 11, 2017

Applies to:

Oracle HTTP Server - Version: 10.1.2.0.2 and later   [Release: AS10gR2 and later ]
Information in this document applies to any platform.

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

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