Developer forum

Forum » PIM » Collation Error when trying to add a property to a product in the PIM

Collation Error when trying to add a property to a product in the PIM

E-mail notifications
Dynamicweb Employee
Brian Zawistowski
Reply
Posted on 11/03/2021 00:49:47

I am getting a collation error on a database hosted on Azure when trying to add a property to a product in the PIM.  Unfortunately, changing the database collation did not solve the problem.  Do you have any ideas for resolving this issue?


Replies

 
Nicolai Pedersen
Posted on 11/03/2021 10:51:53
Reply

Hi Brian

Can you run this one on your database:

SELECT s.name as 'Schema_Name', t.name as Table_Name,
c.name AS Column_Name,
c.collation_name AS Collation
FROM sys.schemas s
INNER JOIN sys.tables t
ON t.schema_id = s.schema_id
INNER JOIN sys.columns c
ON c.object_id = t.object_id
WHERE collation_name is not null AND t.name LIKE 'EcomProductCategory%'
ORDER BY Column_Name

This will give you a list of tables and columns and their collation.

 
Dynamicweb Employee
Brian Zawistowski
Posted on 11/03/2021 16:57:06
Reply

Hi Nicolai,

The results are attached.

 

 

 
Nicolai Pedersen
Posted on 11/03/2021 17:09:46
Reply

So, and what is your DB collation and table collations on these tables?

 
Dynamicweb Employee
Brian Zawistowski
Posted on 11/03/2021 21:14:10
Reply

The database collation is Danish_Norwegian_CI_AS:

There is no table-level collation in SQL Server, as far as I know.

 
Nicolai Pedersen
Posted on 12/03/2021 09:48:21
Reply
This post has been marked as an answer

Hi Brian

Temp tables are used in this particular update statement and those temp tables are created in the server collation on azure - which is SQL_Latin1_General_CP1_CI_AS.

Since Azure SQL server does support changing the server collation, you have to change the collation on the entire database to SQL_Latin1_General_CP1_CI_AS

Votes for this answer: 1

 

You must be logged in to post in the forum