1

Is there a way to change the encoding for the deploy script generated by Sql Server Data Tools from UTF-8 to ANSI?

The problem that I have is that I have a string in a function that contains the caracter "è" and in the generated deploy script a box appears instead of this character.

EDIT: I'm using SSDT with Visual studio 2013 and 2015.

Buda Gavril
  • 21,409
  • 40
  • 127
  • 196

1 Answers1

0

You should change encoding of all files in your project to UTF-8 and deploy script will be correct.

TJS
  • 81
  • 5
  • 1
    Your answer should be some details to understand the cause. – Balagurunathan Marimuthu Sep 23 '16 at 07:56
  • Some time ago I have experienced a same problem and solved it as I said above. I think this is a bug of VS, when it finds any source file with different encoding than utf-8, this fact forces it to sense all other files the same way, but VS still makes deploy script with utf-8. Changing "encoding" tag in XMLs of project files didn't give any effect. Sorry for my short phrases, it because so difficult to write english for me. – TJS Sep 24 '16 at 09:37