I am trying to select a table from a database. However I get a collation error when I try to interrogate for the table/view lists
How can we change the collation for the connection?
There was already an unanswered question by @David_Andrew here: Microsoft SQL Server - Azure .net db collation error
Thanks in advance!
For everyone having the same problem:
Our Database collation was “Lati1_General_CI_AS”. The make.com module requires a SQL_Latin1_GeneralCP1_CI_AS collation.
As with MS SQL DBs it’s not possible to change the collation but only to set it at the time of creation, our solution was to migrate the existing DB to a new one, that has the required collation, that is also required by the make.com MS SQL DB connection.
Hope it helps others!
