modify encoding for database deploy script

Question

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.

I don't know anything off the top of my head, but may be worth pinging the SSDT team on Twitter to see if they have an idea - twitter.com/sqldatatools. — Peter Schott
– Peter Schott, Commented Apr 6, 2016 at 14:12

TJS · Accepted Answer · 2016-09-23 07:53:44Z

0

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

answered Sep 23, 2016 at 7:53

TJS

815 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Balagurunathan Marimuthu Over a year ago

Your answer should be some details to understand the cause.

TJS Over a year ago

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.

Collectives™ on Stack Overflow

modify encoding for database deploy script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related