SQL 2005 Collation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL 2005 Collation

Author

Topic

poser
Posting Yak Master

124 Posts

Posted - 2007-05-01 : 13:43:53

I am installing SQL 2005 on a cluster for the first time.
All our other servers (SQL 2000) are set at collation:SQL_Latin1_General_CP1_CI_AS
I am installing SharePoint on a cluster and it needs to be:
Case Insensitive, Accent Sensitive, Kana Sensitive and Width Sensitive
I can't figure out which collation setting to choose? Can anyone help me out, please?
Thanks in advance for your help
/P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 13:45:55

Sounds default collation. I have sharepoint db on server with default collation, works fine.

poser
Posting Yak Master

124 Posts

Posted - 2007-05-01 : 14:11:24

I just went and checked and by default it goes to Case Insensitive and Accent Insensitive. And where does the Kana and the Width sensitive come in at?

This is what the instructions from MS SharePoint 2007 says the collation needs to be:

SQL Server and database collation
The SQL Server collation must be configured for case-insensitive. The SQL Server database collation must be configured for case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This is to ensure file name uniqueness consistent with the Windows operating system. For more information about collations, see "Selecting a SQL Collation" or "Collation Settings in Setup" in SQL Server Books Online.

So I am really confused.
So has anyone seen this collation request before?
Thanks for all your help
/P

poser
Posting Yak Master

124 Posts

Posted - 2007-05-01 : 15:38:06

Now I understand this a little better.
The "SQL Server Collation" must be Case-Insensitive
The "SQL Server Database Collation" must be CI-AS-KS-WS
So I think if I choose in the setup:
Dictionary Order, Case-Insensitive for use with 1252 Character Set

I think that is what they are asking for, don't you think?
Thanks,
/P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 15:40:17

You can set them in collation settings page during installation, have to choose dictionary sort order to get those options.

poser
Posting Yak Master

124 Posts

Posted - 2007-05-01 : 15:45:02

Im sorry I am so new to this.
In setup after I select the " Dictionary Order, Case-Insensitive for use with 1252 Character Set" another window should pop up to select the Accent-Sensitive?
Thank you for you patience with me. I am installing 2005 for the first time and it's in a cluster and I don't want to mess it up.
/P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 16:10:41

You may need to click on 'collation desinator and sort order' and choose Latin1_General, then you can check accent-sensitive, Kana-sensitive, and width-sensitive.

poser
Posting Yak Master

124 Posts

Posted - 2007-05-01 : 16:43:41

rmiao
You say you have yours set up on default collation for SharePoint.
What is the default collation?
Thanks
/P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-02 : 10:15:02

SQL_Latin1_General_CP1_CI_AS, just like yours on sql2k.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources