• Licensing
  • Network
  • Maps
  • Indoor
  • Other
  • TRBOnet Watch
  • Database
IN THIS ARTICLE

Collation Conflict while updating a DB

Incorrect email!

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:
    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

    3) Execute the query.

Helpful?
We're glad this article helped.

Thanks for letting us know. What went wrong?