April 30, 2004 at 1:52 am
Hello,
I am trying to migrate a single code page MS SQL Server2000 database into a unicode database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. I get unexpected errors everytime I try to use the Enterprise Manager/Query Analyzer to create a new database,and then "play" in the edited script of the old database structure.
Are there any other alternative solutions?
It would be great if you could help!
Thanks,
Sheetal.
May 3, 2004 at 8:00 am
This was removed by the editor as SPAM
May 6, 2004 at 2:57 pm
Sheetal,
Can you post some samples that we might be able to see what you are having problems with?
Basically what I have found is that if your default database collation is different from that of the default database collation for tempdb you will need to use the COLLATE clause to explicitly define the collation for the character type fields. However you should not have any problems changing from varchar to nvarchar, or char to nchar. Going the other way around might cause dataloss though.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply