In Azure, the server and DB collations are CS, and you can't change them. I was looking for a way to generate COLLATE in my query, such as: "select * from Customer where Name = @name COLLATE Xxx_CI and Name = @name" (the predicate is duplicated so that the second allows the query optimizer to use an index seek).
For other readers, I've realized that you can set collation at column level... if you want case sensitive searches on particular columns.
Hello Ara,
Which collation is used in your database? If collation is Xxx_CS (case sensitive) then case-sensitive search will be executed properly out of the box.
Hi Dmitri,
In Azure, the server and DB collations are CS, and you can't change them. I was looking for a way to generate COLLATE in my query, such as: "select * from Customer where Name = @name COLLATE Xxx_CI and Name = @name" (the predicate is duplicated so that the second allows the query optimizer to use an index seek).
For other readers, I've realized that you can set collation at column level... if you want case sensitive searches on particular columns.
Thanks!
Anyway, this isn't crucial. I'll work around it. Thanks!