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?
  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.
  3. ghemant Moderator

    Hi,
    Please refer Books Online about the collations where you can find all the information you wants to know

Share This Page