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:

enter image description here

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.


EDIT: Sorry. this script was made with UTF-8.

  • 1
    The text in the picture looks like UTF-8 encoded text interpreted as (some version of) ISO 8859. It looks like your users are using UTF-8. How about fixing the problem the other way: you adopt UTF-8 instead of forcing old character encodings on your users. By the way, "ANSI" is not a single encoding, it is an umbrella term for about 20 different encodings. – Johan Myréen Sep 19 '18 at 18:41
  • Yes sorry Johan, in this case, UTF-8 was used. – Rafael Piccinelli Sep 19 '18 at 19:37
  • Is your question still current? – miroxlav Nov 18 '18 at 21:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.