Home » SQL & PL/SQL » Client Tools » Spooling file in Unicode format (Oracle 10.1.0.2.0, Windows 2000 Server)
Spooling file in Unicode format [message #297048] Wed, 30 January 2008 00:17 Go to next message
mbhatnagar
Messages: 1
Registered: January 2008
Junior Member
I need to spool a table out to a text file in Unicode format.
This is the query I'm using right now:

SET TERMOUT ON
PROMPT Extracting <table name>
SET TERMOUT OFF
SPOOL <table name>.txt
SELECT Col1||'$$$$!@**'||Col2||'$$$$!@**###' FROM <table name>;
SPOOL OFF

This would create a text file with the same name as the table, only it would be in the ANSI encoding. What I need is to create the text file with Unicode encoding.
Is there a way to do this?

Thanks,
Mayank
Re: Spooling file in Unicode format [message #297070 is a reply to message #297048] Wed, 30 January 2008 00:57 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not with SQL*Plus but I'm pretty sure there are other tools that works in Unicode.

Regards
Michel

Previous Topic: Capture OCI sql HELP
Next Topic: select statement returns blank spaces padded with value
Goto Forum:
  


Current Time: Mon Dec 05 15:16:49 CST 2016

Total time taken to generate the page: 0.14313 seconds