Posts Tagged ‘T-SQL’
Implicit conversion of char value to char cannot be performed because the collation of the value is unresolved due to a collation conflict.
This problem occurs when the referenced database table field has a different collation sequence to the field being tested.
Surprisingly, for me the usual remedy to this type of problem applying “Collate Database_Default” to the other database did not resolve the issue.
Neither did applying it to the local one – but that’s not surprising.
Both the fields being compared were referenced through views stored in the local database (DB), but referencing tables in an external DB.
Even though there were no errors in the views, applying the ‘Collate Database_Default’ in the views resolved the issue.
