SQL Server Performance

What is collation in sql 2005?

Discussion in 'SQL Server 2005 General Developer Questions' started by roshriya, Aug 20, 2008.

  1. roshriya New Member

    What is collation in sql 2005?
    roshriya, Aug 20, 2008
    #2

  2. sql2k8 New Member

    the sorting order in which sql server allocates the data
    examples: case -sensitive
    case-insensitive
    binary,
    etc
    if you give case sensitive as the allocation then you have to type the letters exactly how you have given.
    for case insensitive you can type capital letters as well as small letters.
    sql2k8, Aug 20, 2008
    #3

  3. ghemant Moderator

    Hi,
    Please refer Books Online about the collations where you can find all the information you wants to know
    ghemant, Aug 22, 2008
    #4

Share This Page