1

I am comparing my project with our development database SQL Server and found a bug in the Schema Comparison tool. I found out that any ASCII character over 127 will display as a black diamond question mark, meaning the character is not recognized. In this example, the section symbol § is displaying as a �. On the left hand side of the pane is the function that is included in my database project, and on the right hand side of the pane is the function on the development database server.

Schema Comparison between Database Project and Database Server

Robert Mattson
  • 21
  • 3
  • Just to let you know, the function definition in the project shows the character as a section symbol correctly. – Robert Mattson Oct 28 '15 at 15:40
  • What is your question? – Kevin Robatel Oct 28 '15 at 15:46
  • Why is Schema Compare showing up with these extraneous characters? If I go an use the "Update" function from the Schema Comparison tool, it will replace the character with a black diamond question mark on the database server. Something is definitely wrong with the Schema Compare tool. – Robert Mattson Oct 28 '15 at 17:24
  • What is the database collation set to in the project? (See project properties > Project Settings tab > Database Settings) – Keith Oct 28 '15 at 18:15
  • SQL_Latin1_General_CP1_CS_AS. This is the collation we use on our database server. The character displays fine if I see it from SQL Server, or open the function/stored procedure in the project. – Robert Mattson Oct 28 '15 at 18:36
  • Is it the same one as the database and/or the table/column? I've seen those sometimes be different? Have you tried a comparison using something like Red-Gate's Data Compare? – Peter Schott Oct 29 '15 at 00:11

0 Answers0