Skip to Main Content
Forums

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!

utl_file - ansi vs utf-8 encoding

sskeltonAug 13 2009 — edited Feb 4 2011
We have an AL32UTF8 database.

I am wanting to use UTL_FILE to output text files in UTF-8 encoding in every case.

I get UTF-8 encoded files as long as what I'm outputting has unicode characters requiring it.

However, if I output records having characters represented by the normal ASCII characters (ASCII 0-127 I'm assuming), the text file created by UTL_FILE is ANSI/ASCII encoded.

I want the file to be encoded as UTF-8 in every case, so that users getting our download files always get files having the same encoding.

Is this possible?

Thanks,
Steve
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Aug 13 2009
4 comments
5,546 views