...
- 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 could not be used and had to be reinstalled.
- The client organisation could not change to an accent insensitive collation sequence to change search functionality.
Alongside these limitations, it seems that SQL_ collation sequences are no longer being updated and will eventually be phased out in favour of Windows collation sequences. Some of the newer Unicode characters are not in the SQL collation but do exist in Windows ones.
...