OraFAQ Forum: Client Tools » Spooling file in Unicode format

Home » Other » Client Tools » Spooling file in Unicode format (Oracle 10.1.0.2.0, Windows 2000 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spooling file in Unicode format [message #297048]

Wed, 30 January 2008 00:17

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

Report message to a moderator