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?
Try making an Indexed view and add the collation to the column in the select statement.