Set CP1(code apge) during install...please help !

  •  

    Hi,

    I have a SQL server standard edition that I just installed. I want the collation after installation to read :

    SQL_Latin1_General_CP1_CI_AI , but it shows

    SQL_Latin1_General_CI_AI......

    My question is how in earth I can set the "CP1" during installation ? Can I change this after installation. NOTE, I want to set this for the complete installation, it will not be enough to change it only on the different database levels

     

    Help extremelly appreciated !!

    //Helmut

  • you need to do a rebuild master to change server collation, any existing database you detatch first will then need to be recollated.

    I don't have a free box to step through an install but it's a choice of the sql collation.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • Hi

    Thanks for the answer......what I dont understand is how I can get the "CP1" added to the collation..if I go properties for my sql server installation it reads SQL_LAtin1_CI_AI

    I have reinstalled sql server and I cant understand what to do during installation to get collation equals : SQL_LAtin1_CP1_CI_AI ...I need the CP1 setting for my installation....I want to handle this at installation time because I dont want to start rebuilding stuff in the master DB after installation...it must be possible to get this CP1 already at installation time but how ??? for the case and accent (CI / AS) there are check boxes during install, but what about the CP1 during installation ??

     

    Someone please ??

     

    Best Regards

    Helmut

  • if no-one posts then I'll run an install on sunday on a test server - think you need code page 850 , sorry not really sure I usually install windows collation

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • I am having the same issue.

    The locale of my machine is United Kingdom. I think it is something to do with the locale not being United States.

    I thinkCP1 specifies Code Page 1252, but I am not sure what that means exactly

    I will try and let you know

  • Let me state what I am doing:-

    Fresh install of SQL server 2000

    Selecting custom installation

    Selecting:-

    Lattin1_General

    Acent Sensitive

    I cannot set the collation with the other option as AS is not available

    Once the installation is completed, I can check the SQL server collation and it is set to LATIN1_GENERAL_CI_AS

    I need it to be:-

    LATIN1_GENERAL_CP1_CI_AS

  • OK, here is a quick update, I have managed to get this configured as per my requirements.

    The locale has nothing to do with the collation settings that we need.

    In order to get SQL_LATIN1_GENERAL_CP1_CI_AS

    I had to select the following:-

    'SQL Collations'

    'Dictionary, case-insensitive, for use with 1252 character set'

    I was initially sceptical as it did not mention Accent Sensitivity, but the server defaul seems to be AS.

    I hope this helps any others with a similar issue.

    regards,

    Intersimi

Viewing 7 posts - 1 through 6 (of 6 total)

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