MS SQL Server - SQL Server 7.0 to 2005

Author

SQL Server 7.0 to 2005

Srikanth

2006-02-04, 8:23 pm

We just migrated SQL Servver 7.0 tables to SQL Server 2005.
When we try to export the data of one table to spred sheet we are getting
these error messages
"can not convert nicode and nonunicode string datatypes.
I verified the sort order in 7.0 is 52
and 2005 also 52.
any one any idia what is wrong with these tables.
Thanks
--
SQL serer DBA

Sreejith G

2006-02-05, 1:23 pm

Hi,

Seems like few of the feilds while converting are implicitly judged and
converted causing the error, you need to explicitly say the data type in this
occasion... like said in below post...

Select Cast(xx as nvarchar(50)) xx from <tablename>

http://forums.microsoft.com/MSDN/Sh...=64475&SiteID=1

http://forums.microsoft.com/MSDN/Sh...188735&SiteID=1

Thanks,
Sree

"Srikanth" wrote:

> We just migrated SQL Servver 7.0 tables to SQL Server 2005.
> When we try to export the data of one table to spred sheet we are getting
> these error messages
> "can not convert nicode and nonunicode string datatypes.
> I verified the sort order in 7.0 is 52
> and 2005 also 52.
> any one any idia what is wrong with these tables.
> Thanks
> --
> SQL serer DBA

Sponsored Links