Toad World® Forums

Garbage characters being put into generate.sql


#1

Hello,

I am having an issue with Toad. When I have it generate the DDL script (generate.sql) the 1st three bytes of the file are garbage characters. They are always  which is Hex (ef bb bf).

Any ideas on why I am getting these strange characters in the file? I found out that Toad was doing be when I attempter to load this .sql file into SQL Server. It complained about invalid character.

Thanks,

Jeff


#2

Oh, I am using TDM version 3.1.7.36


#3

Hello Jeff,

The 1st three bytes of the file show in which encoding it is saved - UTF -8 in this case.

Please see:

Feel free to select another encoding for the generated script.
Select the encoding in the Settings menu | Options | Physical Model | SQL Script area | Encoding Used for SQL Scripts.

Hope this will help.

Regards,

Vladka