Is there a way to query SQL Server through one of the system tables/views or one of the Information Schema views to determine if a given collation sequence is case sensitive or not?
Obviously a person can tell by looking at the collation sequence name and see if it is case sensitive or not, but how can you write a query which clearly and is guaranteed to display whether or not a collation sequence is case sensitive?
asked Jul 21 '11 at 06:16 AM in Default
If you do a select
select * from sys.fn_helpcollations()
In the description column you have written whether particular collation is Case Sensitive or Case Insensitive.
Also general rule is the the CS in the collation name means Case Sensitive and CI means Case Insensitive.
If you take a look in the sys.databases and sys.columns system views, you will see collations used for that db/column and by the names and eventually description returned by sys.fn_helpcollations() you can determine whether the collation is Case Sensitive or Insensitive.
answered Jul 21 '11 at 06:25 AM