BUG: Sql Data Compare only saves scripts as Unicode
scollis
Posts: 32 Bronze 3
Hi,
I tried saving the script from the "Review Deployment Script" stage of the deployment wizard. The save dialog gave an option of UTF-8, UTF-8 with Preamble, Unicode and ASCII. However all 4 encoding options only produced the same Unicode file each time.
I was using Sql Data Compare 11.4.3.26 on Windows 10 Enterprise.
I tried saving the script from the "Review Deployment Script" stage of the deployment wizard. The save dialog gave an option of UTF-8, UTF-8 with Preamble, Unicode and ASCII. However all 4 encoding options only produced the same Unicode file each time.
I was using Sql Data Compare 11.4.3.26 on Windows 10 Enterprise.
Comments
Thanks for the information! I've been able to replicate the problem here and have filed a bug report with reference SC-8188. There is a workaround in that you can set the encoding option that you want by going to the Tools menu, then going to Application Options. In the Deployment scripts section you can find a dropdown box labelled Encoding, which you can set to whichever encoding you'd like. This setting is respected.
I've made the developers aware and I'll let you know when I hear anything about a possible bugfix.
Thanks!
Redgate Software