Home > Item Management > Dept/Cat/Groups > How Do I...? > Resolve A Collation Conflict?

How Do I Resolve A Collation Conflict?

We have encountered a problem on ‘some’ SQL Server systems where the Category Maintenance module will result in an error when opened. The error is:

‘Cannot resolve collation conflict for equal to operation.’

This error is due to an inconsistent language collation being used on some tables within the database. To resolve this problem, carry out the following steps:


Open SQL Enterprise Manager and select the Retdata database.


In Tables, right click SUGGESTPERIODADJ and select ‘Design Table’.


Select the STRSTORECODE field and change the ‘Collation’ property to equal ‘<database default>’.


Close the Design Table screen. You will be prompted to save your changes. Click Yes.


Open up the Category Maintenance screen to confirm that this change has removed the error.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)