ISO 8859-15 or ISO 8859-1 in SQL Server?

5k views Asked by At

What collation should be use for ISO 8859-15 or ISO 8859-1 in SQL Server? I have looked around and cannot find references anywhere for this. Any help is greatly appreciated.

1

There are 1 answers

4
thebjorn On

That entirely depends on which language you are going to store. E.g. if you use SQL_Danish_Pref_Cp1_CI_AS_KI_WI then Aarhus will be sorted after Xylophone since aa is a spelling of å, which is after x in the Danish/Norwegian alphabet.