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!

SQL*PLUS ... SPOOL - can file be in UTF-8 format?

872623Jul 5 2011 — edited Jul 5 2011
Hello,

i have written a script that generates XML file out of some data stored in batabase. I am using SQL*PLUS to run it. Now when ever i run script i get .xml file which is in ASCII char set. To successfuly send this XML to web-application i have to manually open it in notepad and save it as UTF-8 file-type.

My question is ... is there a way to tell SQL*PLUS to generate file in UTF-8 character set?


Thank you for your help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2011
Added on Jul 5 2011
4 comments
15,527 views