Difference object text has different character than QA
sebling
Posts: 22
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
"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
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!
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!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