Difference object text has different character than QA

sebling

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

Brian Donahue

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!

sebling

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 Donahue

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!

sebling

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