1 Reply Latest reply: Mar 4, 2012 5:14 AM by Gordon Du RSS

Collation Settings

Gonzalo Gomez Gonzalez
Currently Being Moderated

Hello, good afternoon.

Excuse me for my English, it´s not very good.

 

Upgrading to 8.81 SP00 PL11 the system check the collation settings and it´s incorrect.

i´ve read the note 987436 and i´ve tried the change but it´s imposible to change it.

 

The next step is install SQL again.

Checkin the AdministratorGuide_SQL in the page 17 says:

 

Collation Settings

SQL collations u2013 Dictionary order case-insensitive, for use with 1252

Character set, Accent - Sensitive (SQL_Latin1_General_CP1_CI_AS).

Note

If you manually install SQL Server, in the Collation Settings window, select

Latin1_General from the dropdown list and select the Accent u2013 sensitive

checkbox.

 

If I install SQL in that wayt when i make select SERVERPROPERTY ('collation') the answer is:

Latin1_General_CI_AS

The expected answer: SQL_Latin1_General_CP1_CI_AS

The question is: ¿It´s the same collation?. ¿Is this the correct collation?

How can i install sql with the right collation, in the guide it´s no explicit.

 

Actions