We got garbled

careychencareychen Posts: 2
edited February 20, 2012 11:36AM in SQL Source Control Previous Versions
when I committed my db to SVN, the first time will be successful , but when I make some change, the scc will be compare again, and then got some errors,

Source Compare window will got garbled, then show error message
Error file : C:\Users\Administrator\.......\XXX.sql

When I try to open the file using SSMS , SSMS will got the garbled too. And I found the file not have BOM.
I try to append BOM by manual, the file will open normal .

My language is zh-TW, and using SQL 2008 R2 SP1

Thanks for your helping...
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I believe that SQL Source Control saves the files as UTF8 without Byte Order Marker. I can put in a suggestion that the files are saved with BOM but I don't know if there is a good reason why they don't do that already.

    Is the error you mention in the beginninng definitely caused by an incorrect conversion of the text into the correct locale?
    · Share on Twitter
Sign In or Register to comment.