I am exporting data to a flat file, but it only seem to export in UTF-8 format. I would like it to export in ANSI format. Because it is in a UTF-8 format, the file has the BOM in the first three bytes. The EF BB BF code does not allow me to import it to Unicode unaware programs, such as Access. Is there a way to set the format to ANSI when exporting to a flat file?
WORKAROUND:
None
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.