![clock](../themes/indigo/img/timeicon.gif)
February 14, 2013 05:12 by
Scott
Sometimes you’ll get this error message when queries your database:
"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation"
So, how to fix this error?
![](/image.axd?picture=2013%2f2%2fads_awards_sql2012.gif)
Just use the following syntax to collate on the fly when joining up tables with different collations. I integrate system so have to do this allot.
select * from [Product] p join [category] c
on
c.[Name] collate SQL_Latin1_General_CP1_CI_AS
=
p.[Name] collate SQL_Latin1_General_CP1_CI_AS
Hope this help.