56
Views
2
Comments
MSSQL error: Cannot resolve collation conflict for equal to operation.
Question
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 https://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.
João Fernandes
Hi Colin,

Have you tried using the COLLATE statement?
Check this stackoverflow discussion that is simmilar to yours.
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.