Re: pl/sql, excel, xml, utf-8 data - excel refuses to show data

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 12 Sep 2005 11:43:02 +0100
Message-ID: <mrmai1tc5q66s0seu3v5knnkka02eqicrg@4ax.com>

On Fri, 09 Sep 2005 10:13:39 +0300, Mira Tiilikainen <mira.tiilikainen_at_iki.fi> wrote:

>I try to open excel with data in xml format. The problem is, that if my
>data consists any utf-8 spesific characters (like scandinavian
>characters found in ISO-8859-1 or ISO-8859-15 for example) excel refuses
>to show the data.
>
>I open the excel by calling owa_util.mime_header from pl/sql procedure
>as follows:
>owa_util.mime_header
>( ccontent_type => 'application/vnd.ms-excel'
>);

The HTTP content type header also optionally includes encoding details, so you probably want:

'application/vnd.ms-excel;charset=utf-8'

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Mon Sep 12 2005 - 05:43:02 CDT