Difference object text has different character than QA

seblingsebling Posts: 22
edited December 18, 2006 8:42AM in SQL Compare Previous Versions
I have the following string in a stored procedure:
"Error - Format Error - Invalid Branch Access" ErrorField="0"
SQL Compare shows the text as:
"Error – Format Error – Invalid Branch Access" ErrorField="0"

When I run SQL Profiler to capture the queries that SQL Compare is doing, I see the correct character in the returned query, so the engine must be mis-interpreting this particular character.

Not sure how to resolve this issue

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    How are you getting the text of the stored procedure? Are you looking at the side-by-side windows in SQL Compare, or is this a Toolkit issue when you try to get the SQL code from a difference object?

    Thanks!
  • I see the same result in both the side by side window in SQL Compare and in the toolkit looking at the text property (of the stored procedure) in the difference object.
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi,

    We have tested SQL Compare against Unicode and the characters seem to display just fine. Can you please tell me
    • The version of SQL Compare
    • The version of SQL Server that runs these databases
    • The database and server collation orders
    Thanks!
  • SQL Compare version is 5.2.032
    both source and target db servers are
    SQL Server is Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
    Collation is SQL_Latin1_General_CP1_CI_AS
Sign In or Register to comment.