on 07-02-2008 5:31 PM
How to select the collation SQL_Latin1_General_CP850_BIN2 during SQL Server 2005 installation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
850_BIN2 (unicode) is also known as:
"Binary order based on code point comparison, for use with the 850 (Multilingual) Character Set"
lol, wouldn't have guessed right?
I did select that - after installation it gave me - SQL_Latin1_General_CP850_BIN and NOT SQL_Latin1_General_CP850_BIN2.
At the server or DB level?
Better yet, just run this on your database server while in the master DB.
SELECT CONVERT (varchar, SERVERPROPERTY('collation'))
What's the result?
I stand corrected.
Apparently there are two:
Binary order, for use with the 850 (Multilingual) Character set
Binary order based on code point comparison, for use with the 850 (Multilingual) Character Set
The first time - I have picked the first one above - where I should have picked the second one above.
I am going to give you full points.
Thank you, very much.
Thank you.
And just FYI - We did complain about this inhouse to the SQL developers ... but they came back w/ a very technical explaination why they named the collation page the way they did. Made since back then, but confused a lot of people nontheless.
Glad to be of help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.