We got garbled

careychencareychen Posts: 2
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...

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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?
Sign In or Register to comment.