SQL SERVER ERROR: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

Question

Msg 468, Level 16, State 9, Line 26
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

lacks context. That error can occur in several situations. – Mitch Wheat Aug 01 '22 at 06:00 — Mitch Wheat, Aug 01 '22 at 06:00

score 0 · Answer 1 · edited Oct 19 '22 at 06:17

0

Use the following command and resolve the above issue. DATABASE_DEFAULT i.e

update [TableName] set
    [ColumnName] = [i.ColumnName]
from [TableName] i
where i.[ColumnName] COLLATE DATABASE_DEFAULT = [TableName].[ColumnName] COLLATE DATABASE_DEFAULT

edited Oct 19 '22 at 06:17

Dale K

25,246
15
42
71

answered Jul 22 '22 at 11:10

yasir ali

1
1

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 24 '22 at 23:47

SQL SERVER ERROR: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

1 Answers1