Post reply

Can't Find SQL_Latin1_General_CP1_CI_AS in New Media for SQL Server Install

  • January 13, 2010 at 3:28 pm

    #209122

    The old server I am moving away from has a default server collation of SQL_Latin1_General_CP1_CI_AS. I'm installing a x64 Enterprise flavor on this new hardware and the closest thing I can get is Latin1_General_CI_AS which is not the same and would probably cause problems especially when using tempdb.

    Has anyone worked round this?

    Thanks in advance.

  • January 13, 2010 at 3:37 pm

    #1103354

    Check this page in the middle is code that you can run to find all the collation in the box. Here is the code to run in the master.

    SELECT *

    FROM fn_helpcollations()

    http://msdn.microsoft.com/en-us/library/ms184391.aspx

    Kind regards,
    Gift Peddie

  • January 13, 2010 at 4:41 pm

    #1103365

    r.pe (1/13/2010)

    The old server I am moving away from has a default server collation of SQL_Latin1_General_CP1_CI_AS. I'm installing a x64 Enterprise flavor on this new hardware and the closest thing I can get is Latin1_General_CI_AS which is not the same and would probably cause problems especially when using tempdb.

    Has anyone worked round this?

    Thanks in advance.

    SQL_Latin1_General_CP1_CI_AS is a SQL collation designed for backward compatibility. If you want to install SQL with that collation I believe you have to select SQL collations on the relevant setup page. not an option I choose myself so not sure of details.

    Latin1_General_CI_AS is a default windows collation. SQL selects it as default based on the language settings of the server. To my mind this is the best one to use unless an application requests otherwise.

    The differences between the two are minimal. If you install SQL with the default windows collation and then have a user database with the SQL collation yes it is possible to get problems with tempdb, but they are codable around and infrequent. I have many such setups with no problems. Any app designed to run in western europe\america should run with this collation.

    If you have already done the install with a collation you do not want you can change it using setup. See BOL.

    ---------------------------------------------------------------------

  • January 14, 2010 at 6:23 am

    #1103548

    Thanks guys. I'll do a bit more research too.

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

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