December 29, 2008 at 10:14 am
Hi everyone, I have to deal with this hideous problem again, I have a server that uses SQL Server 7.0 and works with "Binary sort order for the iso 8859-1 (Latin 1) character set" and a Locale ID=33280. Now I am almost sure that its equivalent in sql server 2005 is Latin1_General_BIN because of the compatibility and what Sql Server 7.0 collation means. I wander around in the web and found these two microsoft webs to kinda reasure my thoughts.
Please any help or coments are highly appreciated. Thanks in advance.
http://msdn.microsoft.com/en-us/library/ms143350(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspx
December 29, 2008 at 11:32 am
Can you tell us what exactly is your problem?
* Noel
December 29, 2008 at 1:33 pm
I want to confirm that the collation Latin1_General_BIN is the equivalent for sql server 7.0 collation "binary sort order for the iso 8859-1 (Latin 1) character set". Or which would be the equivalent for it?
Thanks for the reply.
Anyone please??? : (
December 30, 2008 at 8:22 am
Anyone please??? : (
December 30, 2008 at 10:09 am
chileu17 (12/29/2008)
I want to confirm that the collation Latin1_General_BIN is the equivalent for sql server 7.0 collation "binary sort order for the iso 8859-1 (Latin 1) character set". Or which would be the equivalent for it?Thanks for the reply.
Anyone please??? : (
just run:
exec sp_helpsort
* Noel
December 30, 2008 at 2:15 pm
Why don't you restore it on test server and change the database collation under 2005 and test the functionality if you are not getting 100 correct answers.
MJ
December 31, 2008 at 9:00 am
yeah that's what I've done and it works, but I wanted to know if anyone knew for sure that Latin1_General_BIN was the equivalent for the one in sql server 7.0.
Thank you very much for your replies.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply