MSSQL error: Cannot resolve collation conflict for equal to operation.

MSSQL error: Cannot resolve collation conflict for equal to operation.

  
This error occurs when you have a relation operator (LIKE, =, ...) between 2 entity attributes having 2 diferent collations.
This usually happens when using foreign entities, and this foreign entities are from a database with a collation diferent from Latin1_General_CI_AS (which is the OutSystem's recomendated collation for OHE). You may check the DB collation with MS EnterpriseManager, through DB Properties, tab Generalm Group Maintenance, field Collation name.

The MSDN explanation is at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7ory.asp

As a rule of thumb, do always the relation in the following order:
WHERE OHE_Entity.Attribute = ForeignEntity.Attribute
With this sequence, the solution is always:
WHERE OHE_Entity.Attribute = ForeignEntity.Attribute COLLATE Latin1_General_CI_AS


I have the same issue.  I can't change the collation on the external database.  Is there a workaround for this?  I have tried an Advanced query using the COLLATE statement as shown above, but the advanced query doesn't recognise the statement.
Hi Colin,

Have you tried using the COLLATE statement?
Check this stackoverflow discussion that is simmilar to yours.