Skip to main content
pshashipreetham
pshashipreetham19-Tanzanite
19-Tanzanite
August 4, 2024
Solved

Thingworx - MSSQL - COLLATE Change

  • August 4, 2024
  • 1 reply
  • 1022 views

Hi Team,

 

What SQL Commands can be used to Change the Collation/COLLATE of the MS SQL SB?

 

Thanks,

Best answer by pshashipreetham

Ahh found this work around quick, below are the commands need to be used as soon as the MS SQL DB is setup:

 

ALTER DATABASE thingworxv1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE thingworxv1 COLLATE Latin1_General_100_CS_AS_SC;
ALTER DATABASE thingworxv1 SET MULTI_USER;

 

  Change the "thingworxv1" with your database.

 

After the executing these commands, the then COLLATE should be good for the schema setup and Thingworx Installation

 

Thanks,

1 reply

pshashipreetham
pshashipreetham19-TanzaniteAuthorAnswer
19-Tanzanite
August 4, 2024

Ahh found this work around quick, below are the commands need to be used as soon as the MS SQL DB is setup:

 

ALTER DATABASE thingworxv1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE thingworxv1 COLLATE Latin1_General_100_CS_AS_SC;
ALTER DATABASE thingworxv1 SET MULTI_USER;

 

  Change the "thingworxv1" with your database.

 

After the executing these commands, the then COLLATE should be good for the schema setup and Thingworx Installation

 

Thanks,

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
Terms & ConditionsAccessibility statement