ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Changing character encoding

Tomas AlbinssonDec 1 2011 — edited Dec 9 2011

Hi,

I have a procedure in my database that produces a .csv-output for Excel.
Using http headers I get Excel to open the "file" produced.

My problem is our swedish characters, åäö.
Excel (at least Excel 2003) wants iso-8859-1 encoding for these characters to work.
So my procedure uses convert() to go from database charset UTF8 to WE8ISO8859P1.

This worked fine under Oracle Portal but not so under Apex Listener on WebLogic.
I think the listener is converting my iso text to utf on the way to the browser.

Is this so?

I've read that it "defaults to utf8" and "bound to utf8" but nothing official.
My listener version is 1.1.3.243.11.40

Kind regards

Tomas

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2012

Added on Dec 1 2011

2 comments

19,047 views