Collation and Languages

  • Looking on an explanation on the following if possible.

    At an O/S level Windows Server 2008 R2 is configured with Region and Language as English (United Kingdom)

    At a server Collation level the following is configured : LATIN1_GENERAL_CI_AS

    Default Language under Server Properties > Advanced is English

    However Server Properties > General reports English (United States)

    Is this a default that cant be changed ? I havent selected English (United States) at any part of the install process ?

    Many thanks in advance

    Frant101

  • ft55 (1/19/2015)


    Looking on an explanation on the following if possible.

    At an O/S level Windows Server 2008 R2 is configured with Region and Language as English (United Kingdom)

    At a server Collation level the following is configured : LATIN1_GENERAL_CI_AS

    Default Language under Server Properties > Advanced is English

    However Server Properties > General reports English (United States)

    Is this a default that cant be changed ? I havent selected English (United States) at any part of the install process ?

    Many thanks in advance

    Frant101

    According to http://msdn.microsoft.com/en-us/library/ms179254(v=sql.105).aspx, the only way to change the default collation of a server is during install. You can specify a default collation for your database that is separate from the server default collation when you create the database.

    As a side note, the CI_AS part of the collation means Case Insensitive and Accent Sensitive when doing character comparisons. I'm not sure if that would make a difference for UK English, but you should have an idea of what kind of text is in your database and whether you need accent sensitivity or not for your database.

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

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