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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-10 : 09:02:44
|
| warwick writes "This is driving me absolutley nuts....In sheer desperation I need the Teams help to sort this monster of a problem.I am converting a SQL 6.5 database , codepage 850 with german & english data ( including the german "U" with two dots over it - umlatt I think the dots are called. )Anyway, when ever i run the upgrade wizard I only get a small square box in place of where the german "U" should be. I changed local language on the server I am upgrading to , tried making sure the collation on SQL 2000 supports case insensitive, accent insensitive & latin_1 ( collation 1252 ).I even set up a separate DTS data import from the 6.5 server to 2000 as a straight table to table data import ( with the required columns supporting UNICODE ) - no joy!!I have removed any ODBC connections to the SQL 6.5 server in question. Still no joy.Any suggestions?Warwick." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-07-10 : 12:14:01
|
| http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9249http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=16049For lack of a better response, here are two threads from this forum concerning 6.5 upgrades that experienced problems with the wizard.Essentially, they suggest two options to try. One to make sure you have sp 4 or better on 6.5 before you attempt the 2000 upgrade. The other suggests upgrading to 7.0 first, then if that is successful upgrading to 2000.There's no evidence that this will definitely fix your problem, but its something to play with while you identify a solution.... and there is an outside chance they may work. |
 |
|
|
|
|
|
Urgent 6.5 to 2000 Upgrade & code page headache