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

    Question

  • 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.

    Horst
    Tuesday, February 02, 2010 3:22 PM

Answers

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 | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, February 02, 2010 5:06 PM

  • Hi,

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

    http://msdn.microsoft.com/en-us/library/ms143515.aspx

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

    http://msdn.microsoft.com/en-us/library/ms143726.aspx

    From: http://msdn.microsoft.com/en-us/library/aa214297%28SQL.80%29.aspx

    "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.

    BR,

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