My name Tam Dam and I’m a programmer/analyst for the Alamo Colleges in San Antonio, TX.
We’re using Toad for Oracle Professional, rel. 188.8.131.52.
I have to export a table to a tab-delimited (.tsv) file from an SQL script using Toad editor with UTF-8 encoding
to send it to our vendor for processing.
However, the vendor can’t process our file due to the Byte Order Mark (BOM) as the first byte embedded at the beginning
of the file due to the UTF-8 encoding that comes at the vendor’s request.
I’m including the script below and the output (attached):
REPLACE(RTVFSRC_DESC,CHR(9),CHR(32)) "RTVFSRC_DESC", RTVFSRC_IND, RTVFSRC_ACTIVITY_DATE, REPLACE(RTVFSRC_USER_ID,CHR(9),CHR(32)) "RTVFSRC_USER_ID", RTVFSRC_SURROGATE_ID, RTVFSRC_VERSION, REPLACE(RTVFSRC_DATA_ORIGIN,CHR(9),CHR(32)) "RTVFSRC_DATA_ORIGIN", RTVFSRC_VPDI_CODE
order by 1;
Is it possible to turn off the BOM when saving a tab-delimited (.tsv) file with UTF-8 encoding from an SQL script output ?
Currently, it’s the default and only option (that I know of).
Thank you for your help.
rtvfsrc.tsv (431 Bytes)