Skip to content

Sql Server Management Studio Script Encoding

Why are my diffs wrecked?


When you install Sql Server Management Studio (SSMS) 2016 and have it generate script files for you the encoding is set in such a way that git will show them as binary files and your diffs will be useless.

Silvrback blog image sb_float_center

To fix this open SSMS and go to the following menus: Tools » Options » Environments » International Settings. From there changed the Language from "English" to "Same as Microsoft Windows" this setting sets SSMS to save your script files as UTF-8 after you restart the application.