Collation Conflict while updating a DB
The article was successfully sent to the email
The following error (or similar) appears when I update TRBOnet's DB from previous version to a newer one:
This message shows up when Collation in some DB tables does not match the default Collation of the DB.
To resolve the conflict:
This message shows up when Collation in some DB tables does not match the default Collation of the DB.
To resolve the conflict:
-
1) Open the DB in SQL Management Studio, right-click it, and select "New Query".
2) Copy the query below and paste it.
alter table Devices alter column driver_name nvarchar (200) collate DATABASE_DEFAULT
alter table Devices alter column name nvarchar (200) collate DATABASE_DEFAULT
alter table Devices alter column name nvarchar (200) collate DATABASE_DEFAULT
3) Execute the query.