You must Sign In to post a response.
  • Category: SQL Server

    What is the Advantages this type table Creation


    I saw one of the table as follows

    [counername] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

    here why we have added this line
    COLLATE SQL_Latin1_General_CP1_CI_AS NULL

    what is advantages this how it will be created?

    any one explain this

    I think Case sensitive related this?
  • #761370
    Collate represents the collation applied to the character column. This is the default collation applied to character columns in SQL server.

    In your case SQL_Latin1_General_CP1_CI_AS has been set to the column;

    To understand the Collation SQL_Latin1_General_CP1_CI_AS subjected; Please refer the below URL

    Please mark this as Answer, if this helps

    Alwyn Duraisingh.M 
    << Database Administrator >>
    Jesus saves! The rest of us better make backups...

  • #761381
    Hello Kumar,

    It uses to reduce the scope of differing results that the incompatible SQL Server and Windows code pages cause.

    CP1 - Codepage 1

    CI - Case Insensitive

    AS - Accent Sensitive

    Hope this will help you.

    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • Sign In to post your comments