Comparison and sort order of special language character is controlled by Collation or accent sensitive flag


  • Hello,
    we have a problem with special characters of european languages and their comparison and sort orders. Is sorting organized by the right collation or is it switched on/off by using the accent sensitive flag. Exploring the web I could only find that accent sensitive is used for charecters with accents like á but not for the German ä (ae) for example.
    Thank you.

    Tuesday, February 02, 2010 3:22 PM


All replies

  • I'm swedish, but I have a feeling that same applies to German. The letter ä do not have accents, it is treated as a seperate letter (in contrast to "a" with accent). I.e., for any type of swedish collation, a will never equal ä.
    Tibor Karaszi, SQL Server MVP | |
    Tuesday, February 02, 2010 5:06 PM

  • Hi,

    From following link you can find collation sort order options for SQL Server:

    Keep also in mind that collation is defined in server, database, column and expression level:


    "Sensitive or insensitive to accented characters, also known as extended characters. Accented characters are those characters that have a diacritical mark, such as the German umlaut (ë) or the Spanish tilde (~). For example, accent sensitivity defines whether 'a' is equal or not equal to 'ä'."

    Here in Finland we usually use Finnish_Swedish_CI_AS to get ä,ö and å sorted right.

    Hope this help.


    • Marked as answer by Horst.B Thursday, February 04, 2010 12:26 PM
    Tuesday, February 02, 2010 5:09 PM