I am having issue with the encoding of script created by Toad.
I had set UTF-8 as encoding in the following 2 places:
Scripts–>spool file encoding
I have some functions in the database, some functions have some special character inside, for example, French accent letter ‘é’, when I create function script in Toad(one file per object), the script files of those functions with the special character are in ANSI encoding, for those functions do not have the letter, the script file was generated with UTF-8 encoding, by the way, i verified the encoding by opening the file with Notepad++, which can tell me the encoding.
I have issue with ANSI encoding script file.
Is this a bug or anywhere I didn’t configure? For the functions with special character are supposed to be generated as UTF-8 encoding, other than ANSI. I tested package scripts, got same results. The scripts generated using SQL Developer works fine.
My toad version is Toad for Oracle xpert 64-bit, 22.214.171.124
Thanks in advance for your comments and help.