a.stringfieldFoo = b.stringFieldFoo
if this comparison gives the following error :-
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Then it can be corrected in the following way
a.stringfieldFoo COLLATE Latin1_General_CI_AS = b.stringFieldFoo
quick solution!
if this comparison gives the following error :-
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Then it can be corrected in the following way
a.stringfieldFoo COLLATE Latin1_General_CI_AS = b.stringFieldFoo
quick solution!
No comments:
Post a Comment