Users running ANSI scripts are having problems with special characers Long story short. How can I fix users environments, to make them run our scripts using ANSI encode?

The problem is, we send them scripts to run on their databases using ANSI encode. 

But some of them are returning to us with this problem:



We tried to say "please upgrade your software to run our scripts using ANSI encode" but most of them can't do this. 

Is there a way for us, developers ( not me at all, I'm the DBA trying to help here ) to do something ?? WE have this problem since ever. we read all the internet and we couldnt fix this issue.

Thanks
First question would be: "What does ANSI encoding mean?"

Answer depends on your Windows, see this list:  National Language Support (NLS) API Reference (column "ANSI codepage")

Let's assume you have a "western" Windows, then ANSI encoding most likely means Codepage 1252

In this case you must set your NLS_LANG environment value accordingly to NLS_LANG=.WE8MSWIN1252

See also https://stackoverflow.com/questions/33783902/odbcconnection-returning-chinese-characters-as/33790600#33790600

As far as I remember SQL scripts must not have any BOM (Byte Order Mark) at the beginning.