February 27, 2002 at 3:46 am
I am about to upgrade a 7.0 database to SQL 2000 and at the same time upgrade it´s Sort Order.
The database has the following Sort Order:
* Code Page 850
* Sort Order = 58, scand_nocasepref (Case-insensitive Scandinavian dictionary sort order)
...and it must be (after upgrade):
* ISO 8859-1 (Latin-1)
* Sort Order = 185, svfi2_nocasepref (Case-insensitive Swedish/Finnish dictionary sort order)
DTS perhaps or just attach database, if that works?
The customer must not upgrade to SQL 2000 but if this simplifies then it´s ok for them.
CA
CA
February 27, 2002 at 10:42 am
Sorry, no experience on this. I'd double check all the information in BOL and on TechNet.
Steve Jones
March 3, 2002 at 6:28 am
Check out my FAQ on this topic. It is very simple to do.
March 6, 2002 at 2:55 am
Hi!
It worked to attach a database from SQL 7.0 to SQL 2000 with different sort. SQL 2000 upgraded the language in the attach process!
What should be the the best way to change sort order/character set between two SQL 7.0 servers?
Thanks eiljacobson for your answer, but this ALTER command didn´t work? Query analyser did not understand anything... I must do something wrong.
/Christian A
CA
CA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply