Post reply

SQL_Latin1_General_CP1_CL_AS

  • June 12, 2006 at 9:33 am

    #61268

    Is there any collation by "SQL_Latin1_General_CP1_CL_AS" exists in SQL Server?

     

    Please note CL it is "C" "L" not "i".

    I know that the default collation level is

    SQL_Latin1_General_CP1_CI_AS

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • June 12, 2006 at 10:28 am

    #643167

    BOL article "SQL Collation Name" list SQL Collations for both SQL Server 2000 and 2005. Both articles (2000 and 2005)  don't contain this one in the list and the whole article does not contain the string CL until the references containing the word "Declare" containing CL.

    Regards,Yelena Varsha

  • June 13, 2006 at 5:57 am

    #643328

    CI means case-insensative, and CS means case-sensative. It's one or the other, so I'm not sure if any other values would make sense.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply