Post reply

Installation: latin1_general_CP1_CI_AS and latin1_general_CI_AS

  • July 13, 2006 at 3:59 am

    #103200

    Hi guys,

    I have installed SQLServer 2005, after the installation I have found the collation : latin1_general_CP1_CI_AS, but I want the collation sql 2005 latin1_general_CI_AS.

    During installation what is the right collation name to have: latin1_general_CI_AS ?

     

    thank a lot

  • July 17, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 17, 2006 at 2:15 pm

    #649674

    It looks like you wanted a Windows collation during installation, but selected a SQL collation instead.  I can not find any windows collations that look like this: latin1_general_CP1_CI_AS.  The CP (Code Page) leads me to believe this is a SQL collation.  The windows collations don't have a code page.

    You have two choices at this point, changing the default server collation (which involves a lot of work) or just remember to specify the collation you want on user databases you create.  Be sure to read BOL if you are considering reinstalling SQL and already have user databases set up.

    hth,

    Lynn

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

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