Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Please add missing properties to COLLATIONPROPERTY built-in function and/or sys.fn_helpcollations()

The COLLATIONPROPERTY function ( https://docs.microsoft.com/en-us/sql/t-sql/functions/collation-functions-collationproperty-transact-sql ) currently reports on four properties:

CodePage, LCID, ComparisonStyle, and Version.

However, there are several other properties of collations that are not available via those properties.

sys.fn_helpcollations() doesn't have CodePage or LCID. ComparisonStyle and VersionIt can be derived by parsing the Description field, but yuck.

1 vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base