Is UTF-8 encoding available in Select To File CSV exports? If so, how is this accomplished?
Goal: Using "Select to file" activity in automation, export CSV encoding as UTF-8. It currently exports encoding Western (Windows 1252) with no apparent option to change.
Although supporting encoding options incl. UTF-8, the "Export Wizard" activity doesn't seem to be an option as the wizard requires me to select a single database per script. The script queries multiple databases within a federated database. If there's a solution to this, I am open to review.
System: Windows Server 2012
Software: Toad Data Point 184.108.40.206 (64 bit) Registered/Licensed
I located this thread which states TDP 3 Select To File defaults to UTF-8 but this is not the case in TDP 5. The thread ends with a workaround using File Wizard but in my case, this is not applicable.