Collation issue when using merge

Question

Trying to load data from TableA (Source) to TableB (Target) by Merge query.

One of the columns in TableA is Latin1_General_CS_AS, while the target column in TableB is Latin1_General_CI_AS.

Should I firstly change collation setting in Table B before running the merge query?

Answer 1

Hi @Ron

Should I firstly change collation setting in Table B before running the merge query?

Yes, you can alter the column definition like this:

ALTER TABLE TableA ALTER COLUMN Column1 varchar(100) COLLATE Latin1_General_CI_AS;

Also, you can just CAST the collation in the merge statement like this:

MERGE INTO TableB AS target 
USING TableA AS source
ON target.Column1 COLLATE Latin1_General_CI_AS = source.Column1 COLLATE Latin1_General_CI_AS

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".