# Export Dataset as Unicode Text File? **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [August 28, 2013, 1:53pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526 "2013-08-28T13:53:31Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![R2eq1](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@R2eq1](https://forums.toadworld.com/u/R2eq1)\ **Post date:** [August 28, 2013, 1:53pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/1 "2013-08-28T13:53:31Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 28, 2013, 1:59pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/2 "2013-08-28T13:59:42Z")
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](mailto:bounce-R2eq1@toadworld.com)] **Sent:** Wednesday, August 28, 2013 3:54 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [Toad for Oracle - Discussion Forum] Export Dataset as Unicode Text File? **[Export Dataset as Unicode Text File?](http://gyk.r.mailjet.com/redirect/0gswhkro4r3k9s2s2xpbw4/www.toadworld.com/products/toad-for-oracle/f/10/t/20231.aspx)** 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](http://gyk.r.mailjet.com/redirect/khyph493mc2jrysb09kq54/www.toadworld.com/products/toad-for-oracle/f/10/t/20231.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/m5wctn55z8gn9z8ohq40tk/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/54jdtp4nk02pnzg95ds9tf/www.toadworld.com/products/toad-for-oracle/f/10/t/20231.aspx?AbuseContentId=37eff2e0-8eec-4317-80f8-4a17e21b933f&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/ba09a03a/4C7i3y.gif) ---
**Author:** ![R2eq1](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@R2eq1](https://forums.toadworld.com/u/R2eq1)\ **Post date:** [August 28, 2013, 2:09pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/3 "2013-08-28T14:09:52Z")
I have that encoding dropdown but the options are ANSI, and various UTF encodings. Unicode is not an option. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 28, 2013, 2:14pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/4 "2013-08-28T14:14:36Z")
“UTF16 little Endian” will give the same as notepad’s “Unicode” **From:** R2eq1 [[mailto:bounce-R2eq1@toadworld.com](mailto:bounce-R2eq1@toadworld.com)] **Sent:** Wednesday, August 28, 2013 4:10 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Export Dataset as Unicode Text File? **[RE: Export Dataset as Unicode Text File?](http://gyk.r.mailjet.com/redirect/4wk7t0br55xxj4h25w9xjc/www.toadworld.com/products/toad-for-oracle/f/10/p/20231/40970.aspx#40970)** 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](http://gyk.r.mailjet.com/redirect/rbwthlb1gc1wl7w0s2pcgp/www.toadworld.com/products/toad-for-oracle/f/10/t/20231.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/zcjbtf84pov8khdvh6mlcr/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/309ktsd5b4nfmykpow9m4f/www.toadworld.com/products/toad-for-oracle/f/10/p/20231/40970.aspx?AbuseContentId=c58cf386-8561-4032-9568-0c57653d9eeb&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/1803e52d/4C7Ce5.gif) ---
**Author:** ![R2eq1](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@R2eq1](https://forums.toadworld.com/u/R2eq1)\ **Post date:** [August 28, 2013, 2:45pm UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/5 "2013-08-28T14:45:26Z")
That worked perfectly, thanks for the help! ---
**Author:** ![nyamaa](https://avatars.discourse-cdn.com/v4/letter/n/c6cbf5/32.png) [@nyamaa](https://forums.toadworld.com/u/nyamaa)\ **Post date:** [May 18, 2022, 3:43am UTC](https://forums.toadworld.com/t/export-dataset-as-unicode-text-file/26526/6 "2022-05-18T03:43:01Z")
If you always want to use Unicode, configure it below: Menu View -\> Toad Options -\> Files -\> General -\> Default encoding =\> change UTF-8