Save UTF-8 without bom in teamcoding

Toad for Oracle
1

Hi,
when executing sql files generated via teamcoding i always get the following error:

SP2-0734: unknown command beginning "SET DEF..." - rest of line ignored.

I have already learned in the forum that the likely proble is that the files are encoded utf-8 with bom, so i tried to fix it by switching in the editor to utf-8 without bom. This did nothing.

is there any other configuration for teamcoding to do?`

Thanks in advance

2

I am fairly certain that SQL*Plus can only take ANSI encoded files.

Have you tried Options -> Files -> General -> Default Encoding? (Note, if you change that, it will not modify files already in Team Coding..it would affect new files)

3

Hi,

thanks for your reply. i switched to uft-8 before because of problems with german specific characters. These result in an error when running them via sqlplus.

Ok i have now switched to UTF-8 deleted the files loaded them back in form toad:

image
image732×387 77 KB

The error is still the same:

image
image808×138 3.88 KB

4

For me, SQL*Plus only works with ANSI encoded file.

I get the same as you when I save as UTF-8. I get different (but also wrong) results when I use any of the other encodings. Can you specify a character set to use with ANSI so that German characters will work correctly?

Another possibility - you can use QSR instead of SQL*Plus and it will handle all of these encodings.

5

SQL Plus works with UTF-8 (no BOM)

6

For me, SQL*Plus does not support unicode, even when encoded as UTF8 (no BOM). See below.

Please let me know some steps to make it work.

SQLPlusUnicode2