# Import Data Wizard Creating UTF BOM ï»¿ Characters in a file export with sql statements

**URL:** <https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 6, 2021, 7:28pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749 "2021-05-06T19:28:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ORA-digit](https://avatars.discourse-cdn.com/v4/letter/o/b2d939/32.png) [@ORA-digit](https://forums.toadworld.com/u/ORA-digit)\
**Post date:** [May 6, 2021, 7:28pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749/1 "2021-05-06T19:28:55Z")

</div>

Toad Version : 13.1.1.5 Toad For Oracle Xpert Edition(64-bit)

 ![ToadFileCreationEncodingOptioin](https://global.discourse-cdn.com/quest/original/2X/c/cb0811fa0dccb40ec8196234248a00c468bfb326.jpeg)

Is there any way we can avoid these BOM ï»¿ Characters from generated file while exporting sql statements.

Thanks you in advance for your help.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [May 6, 2021, 10:45pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749/2 "2021-05-06T22:45:29Z")

</div>

Welcome to the Toad/Oracle forum.

I'm not seeing any other option within the Toad Options base that could impact the chars embedded in that output. Might need one of the dev guys to take a look at this one.

---

<div class="post-metadata">

**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:** [May 7, 2021, 12:58pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749/3 "2021-05-07T12:58:38Z")

</div>

It looks like we always save that file as UTF8, no matter what. I can add an option to control this in the next version.

As a workaround, after Toad creates the file, open it with notepad, then re-save it with the encoding that you want.

---

<div class="post-metadata">

**Author:** ![ORA-digit](https://avatars.discourse-cdn.com/v4/letter/o/b2d939/32.png) [@ORA-digit](https://forums.toadworld.com/u/ORA-digit)\
**Post date:** [May 27, 2021, 3:48pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749/4 "2021-05-27T15:48:49Z")

</div>

Thank you for response

---

<div class="post-metadata">

**Author:** ![ORA-digit](https://avatars.discourse-cdn.com/v4/letter/o/b2d939/32.png) [@ORA-digit](https://forums.toadworld.com/u/ORA-digit)\
**Post date:** [May 27, 2021, 3:49pm UTC](https://forums.toadworld.com/t/import-data-wizard-creating-utf-bom-i-characters-in-a-file-export-with-sql-statements/52749/5 "2021-05-27T15:49:15Z")

</div>

Thank you for response John
