modify encoding for database deploy script

658 Views Asked by At

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.

1

There are 1 best solutions below

2
TJS On

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