January 19, 2015 at 10:25 am
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
January 19, 2015 at 3:03 pm
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