Link to home
Start Free TrialLog in
Avatar of M
M

asked on

What is accent sensitivity properties?

Context: Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.

From: https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15

Research from the same URL above:

Accent-sensitive (_AS)Distinguishes between accented and unaccented characters. For example, "a" is not equal to "ấ". If this option isn't selected, the collation is accent-insensitive. That is, SQL Server considers the accented and unaccented versions of letters to be identical for sorting purposes. You can explicitly select accent insensitivity by specifying _AI.

ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of M
M

ASKER

Thank you Olemo, a second opinion is welcomed.