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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy