Collations on indexes in SQL Server

Question

I am interested if there is a possibility to specify collation for a column when creating index that is different from the collation of that column? And when indexed, are string data sorted according to collation of column or collation of database?

Answer 1

You can create the calculated field with needed collation and create the index on this field.