Export Dataset as Unicode Text File?

I am using Toad 10.1 to extract data from a database in order to use it with another application. This application needs the data files to be in unicode text file format or else the text fields will not come in properly. I can export delimited text files as ANSI or UTF-8 but not unicode and was hoping that there was a solution to this that someone knows about.

If the dataset is small enough I can always open it in notepad and save it as unicode but now I have some files that are too large to be opened in notepad. If I could just extract them as unicode in the first place it would prevent this issue altogether. Is there a way to do that?

Thanks in advance.

I don’t have Toad 10.1 installed anywhere, but in 10.5 and newer there is a dropdown for “Encoding” right on the ‘export data’ dialog in Toad. If you don’t
see that, then an upgrade will get you this feature.

From: R2eq1 [mailto:bounce-R2eq1@toadworld.com]

Sent: Wednesday, August 28, 2013 3:54 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Export Dataset as Unicode Text File?

Export Dataset as Unicode Text File?

Thread created by R2eq1

I am using Toad 10.1 to extract data from a database in order to use it with another application. This application needs the data files to be in unicode text file format or else the text fields
will not come in properly. I can export delimited text files as ANSI or UTF-8 but not unicode and was hoping that there was a solution to this that someone knows about.

If the dataset is small enough I can always open it in notepad and save it as unicode but now I have some files that are too large to be opened in notepad. If I could just extract them as unicode
in the first place it would prevent this issue altogether. Is there a way to do that?

Thanks in advance.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

I have that encoding dropdown but the options are ANSI, and various UTF encodings. Unicode is not an option.

“UTF16 little Endian” will give the same as notepad’s “Unicode”

From: R2eq1 [mailto:bounce-R2eq1@toadworld.com]

Sent: Wednesday, August 28, 2013 4:10 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Export Dataset as Unicode Text File?

RE: Export Dataset as Unicode Text File?

Reply by R2eq1

I have that encoding dropdown but the options are ANSI, and various UTF encodings. Unicode is not an option.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

That worked perfectly, thanks for the help!

If you always want to use Unicode, configure it below:

Menu View -> Toad Options -> Files -> General -> Default encoding => change UTF-8