topic Re: Collation Conflict – SQL in Load Script in QlikView

Collation Conflict – SQL in Load Script

wonkymeister — Mon, 21 Oct 2019 10:51:14 GMT

Never had this issue before, on load of a large SQL script. Any ideas of a solution?

OleDb error

Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

Re: Collation Conflict – SQL in Load Script

marcus_sommer — Mon, 21 Oct 2019 13:17:01 GMT

Maybe this is helpful: http://www.ashishblog.com/how-to-resolve-the-collation-conflict-and-how-to-check-collate-in-sql-server/

- Marcus

Re: Collation Conflict – SQL in Load Script

wonkymeister — Mon, 21 Oct 2019 14:23:49 GMT

sorted, cheers!