Unicode collation settings won't stick

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 2000 Forums

SQL Server Administration (2000)

Unicode collation settings won't stick

Author

Topic

humachieve
Starting Member

2 Posts

Posted - 2002-11-26 : 15:29:21

I recently had to reinstall SQL Server 7 on a Windows 2000 machine. When I did this, I selected "Accent-insensitive" in the Unicode Collation settings dialog. After installing and attempting to restore a database, I found that that setting had been ignored.

I then ran rebuildm to reset the settings. From the "Rebuild Master" dialog, I clicked on the "Settings..." button. I then checked "Accent-insensitive" and hit OK. When I clicked "Settings..." again, I found that checkbox remained unchecked.

Is there any reason why I can't select that as an option? I had no problems doing this before I had to reinstall.

thanks.

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-12-02 : 01:21:10

hi hum

check you haven't specified sort order as binary

from BOL

quote:

Sort Order
Select Sort Order options to use with the Collation Designator selected. Binary is the fastest sorting order, and is case-sensitive. If Binary is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available. For more information, see Windows Collation Sorting Styles.

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

humachieve
Starting Member

2 Posts

Posted - 2002-12-02 : 13:40:13

Not binary. Sort order is "Dictionary order, case-insensitive, uppercase preference." It appears to only be the Unicode Collation that won't stick. If I change "Character Set" or "Sort Order," they will be retained when I hit OK and come back into Settings.

All I need is for that Accent-insensitive check box to remain checked! Truly frustrating.

Thanks.

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-12-08 : 21:01:04

hi hum

sorry but no ideas. please post back when and if you find out what is causing it.

cheers

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources