locked
what is collation and when and where it require RRS feed

  • Question

  • User264732274 posted

    please tell me what is collation and when and where it require. what is the usage of collation. thanks

    Thursday, November 10, 2016 2:03 PM

Answers

  • User-654786183 posted

    Collation is a property assigned to any character field that defines the sort and comparison rules for the field.  Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set. Other collations will sort in different orders.  Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type.

    Refer the following MSDN links for more details

    Collation and Unicode Support

    COLLATE (Transact-SQL)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 10, 2016 3:00 PM
  • User364663285 posted

    Collation can be simply thought of as sort order.

    In English (and it's strange cousin, American), collation may be a pretty simple matter consisting of ordering by the ASCII code.

    Once you get into those strange European languages with all their accents and other features, collation changes. For example, though the different accented forms of a may exist at disparate code points, they may all need to be sorted as if they were the same letter.

    Read:

    https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

    for way to change collation in SQL server.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 11, 2016 2:50 AM

All replies

  • User-654786183 posted

    Collation is a property assigned to any character field that defines the sort and comparison rules for the field.  Collation controls the way string values are sorted. The default collation sorts alphabetically using the standard Latin character set. Other collations will sort in different orders.  Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type.

    Refer the following MSDN links for more details

    Collation and Unicode Support

    COLLATE (Transact-SQL)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 10, 2016 3:00 PM
  • User364663285 posted

    Collation can be simply thought of as sort order.

    In English (and it's strange cousin, American), collation may be a pretty simple matter consisting of ordering by the ASCII code.

    Once you get into those strange European languages with all their accents and other features, collation changes. For example, though the different accented forms of a may exist at disparate code points, they may all need to be sorted as if they were the same letter.

    Read:

    https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

    for way to change collation in SQL server.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 11, 2016 2:50 AM