RcBuilder@walla.com
call centre: 054-5614020

Cannot resolve the collation conflict

Posted by: RcBuilder  /   Category: BUGS / Collation / SQL   /   1 Comment
28
May
2014

Bug: Cannot resolve the collation conflict between .. and .. in the equal to operation error message: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation problem: different table collation can caused when working with Linked Server fix: use COLLATE DATABASE_DEFAULT example: select ... from t1, t2 where t1.Name COLLATE DATABASE_DEFAULT = t2.Name COLLATE DATABASE_DEFAULT -- join.

Read more
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים