What is sql collation and how we can change in sql virtual machine on azure? Sql collation: like: SQL_Latin1_General_CP1_CI

What is sql collation and how we can change in sql virtual machine on azure?

Sql collation: like: SQL_Latin1_General_CP1_CI_AS

Breaks up into interesting parts:

1. latin1 makes the server treat strings using charset latin 1, basically ascii

2. CP1 stands for Code Page 1252

3. CI case insensitive comparisons so 'ABC' would equal 'abc'

4. AS accent sensitive, so 'ü' does not equal 'u'

AzureTalks