Hi Clive,

The collating sequences starting with "SQL_" are used for compatibility and it is a "feature" that they ignore the "-" in indexes. So probably Latin1_General_CI_AS works better (if you don't want this).

I am going to test with SQL Server 2019 and
Latin1_General_100_CI_AS_SC_UTF8. Until now it works, but I have done very little with Unicode values.