Skip to content
← SQL Data Compare

How can we improve SQL Data Compare?

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Is there a reason you are using UCS-2 LE BOM encoding instead of UTF-8 (it makes the file twice the size)

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Marty shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Marty commented  ·   ·  Report

    Mark, sorry, yes, I should have been more specific. I was talking about the deployment script. Thank you for pointing me to Tools > Application Options. It was defaulting to Unicode (UTF-16) and I simply changed it to UTF-8.

  • AdminMark Jordan (Software Engineer, Redgate) commented  ·   ·  Report

    Thanks for the suggestion - could you add some more detail about where you're seeing this file encoding being used? For example, if it's in the deployment script you should be able to change the default encoding from the Tools > Application Options dialog

    I'm not sure about the actual reason (depending on where in the UI it's a problem) but it's probably something like historical versions of SSMS requiring a specific encoding to work - we might end up deciding that we should just be using UTF-8 everywhere but removing options does tend to make a few people unhappy, so we'd have to be careful there :)