When I use Export Blobs to export to text file, I am seeing some special characters in the beginning of the exported data. For example Ã¯Â»Â¿. Also, the exported text file is being created with UTF encoding.
Cause could not be determined. Issue very rare and not reproducible on every box.
WORKAROUND 1: Use Export Dataset instead of Export Blobs. In the Export Dataset, you can specifically set the encoding of the text file that you want to export to as ANSI.
WORKAROUND 2: If you must use Export Blobs, this issue seems only to happen with Toad 11.0. Try upgrading to 11.5 and above.