Difference in Collations?

  • Hi my vendor wants me to have a sql 2012 install with

    Latin1_General_CP1_CI_AI collation

    but during the install I have only SQL_Latin1_General_CP1_CI_AI available to chose.

    Any idea how to proceed?

    Warmest Regards

    Paresh Motiwala

    Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA

  • Paresh Motiwala (2/6/2014)


    Hi my vendor wants me to have a sql 2012 install with

    Latin1_General_CP1_CI_AI collation

    but during the install I have only SQL_Latin1_General_CP1_CI_AI available to chose.

    Any idea how to proceed?

    Warmest Regards

    Paresh Motiwala

    I would be asking the vendor to confirm the collation that they need. I do not think that Latin1_General_CP1_CI_AI exists either

  • You can try SQL_Latin1_General. It is reported to show as Latin1_General_CP1_CI_AI after installation.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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