Skip to Main Content

SQL & PL/SQL

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!

What's the best way to export UTF8 data into Excel?

Santosh DeshmukhOct 6 2010 — edited Oct 8 2010
Hi,

Database charterer set is UTF8
PARAMETER VALUE
1 NLS_NCHAR_CHARACTERSET UTF8
2 NLS_CHARACTERSET UTF8

My requirement is that I want to export oracle data into excel file by using UTL_FILE oracle supplied package.
But while writing data into excel files it’s looses in UTF8 encoding and writes some garbage data into file.
I am very much sure that while retrieving the data form database it is perfectly encoded with UTF8, but after data is written to the file it eats the UTF encoding resulting into some garbage data.
e.g.
I am retrieving this filed from database which is UTF8 encoded in DB “Langäcker 55” but when it is written into excel it becomes “Langäcker 55”.
Is Oracle UTL_FILE eating the UTF8 encoding while writing into file? if yes, is there utility which can help me to remain the UTF8 encoding as it is while writing in to excel file? Is there anythingi can do in Oracle to get this done?

Thanks in advance.

Thanks,
Santosh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2010
Added on Oct 6 2010
5 comments
1,014 views