Wojciech Szabowicz Wojciech Szabowicz - 5 months ago 18
SQL Question

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AI" and "Latin1_General_CI_AI" unified on code level

Ive got a question about Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AI" and "Latin1_General_CI_AI", now I know it can be set in sql using COLLATE SQL_Latin1_General_CP1_CI_AI, but I have an app that connects to different Dbs and not all are throwing that exception. Is there a way to support this on code level?

Answer

not ideal but just include where the data joins in your script:

collate database_default