SQL Server Collation
The answer is: Latin1_General_CI_AS. (the windows collation)
This is Microsoft’s recommendation. It’s in article 322112 Comparing SQL Collations to Windows collations.
References
- Collation Hell (Part 1) by Dan Guzman
The answer is: Latin1_General_CI_AS. (the windows collation)
This is Microsoft’s recommendation. It’s in article 322112 Comparing SQL Collations to Windows collations.