A collation sequence is a database setting that controls how string values are ordered.
In Synergetic V67 and all prior versions the collation sequence was required to be the SQL collation 'SQL_Latin1_General_CP1_CI_AS'. The SQL server must also have been installed with that collation sequence and that determined the collation sequence of the master and temp databases of that SQL Server instance.
This caused the following limitations in a client organisation's use of Synergetic:
- The Synergetic databases had to be installed on a SQL instance configured with the specific SQL collation sequence required by Synergetic.
- If the host SQL Server instance was installed with a different collation sequence the instance had to be removed and reinstalled.
- The client organisation could not change to an accent insensitive collation sequence to change search functionality.
Alongside these limitations, future versions of SQL server may not support SQL collation sequences with the preference moving to native Windows collations sequences.
To remove these limitations and future proof Synergetic for potential changes to collation sequence support, changes have been made to support different collation sequences.
In V68, the collation sequence of the Synergetic database can be changed to any Case Insensitive (CI) collation sequence and is also permitted to be different to the collation sequence of the SQL Server instance.
For most client organisations this change will be invisible. If the organisation has created user triggers and procedures that use the temp DB and the Synergetic database uses a different collation sequence, they may have to change that user code.