Browse by Tags

All Tags » SQL Server (RSS)
Cannot resolve the collation conflict...
Fri, Nov 26 2010 3:29 PM
Ever tried to do a join on text columns? Like this: SELECT * from LocationAustralie la left join steps s on la.StepText = s.Value If your tables have different collations you get the error message: Msg 468, Level 16, State 9, Line 2: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in... Read More...
by Dries Marckmann | with no comments
Filed under: ,