Red Gate forums :: View topic - Error while data comparie
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Error while data comparie

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
reval_pradeep



Joined: 11 Jul 2011
Posts: 3

PostPosted: Tue Jul 12, 2011 6:37 am    Post subject: Error while data comparie Reply with quote

When I was comparing data between 2 database. I was getting following error

" The following error message was returned from the SQL Server:

[131] The size (6000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).

The following SQL command caused the error:

SELECT [SpecElementID], [SpecElementIDLbDependent], [StructureId], convert(nvarchar(6000),[Formula]) COLLATE Latin1_General_BIN , [ParentStructureId]
FROM [dbo].[tbCoElementSpecRefLinkBase] WITH (NOLOCK) ORDER BY [SpecElementID], [SpecElementIDLbDependent], [StructureId] "


and same error occure while comparie text datatype. Anybody could give me a solution
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Tue Jul 12, 2011 1:39 pm    Post subject: Reply with quote

Thanks for your post. Are the schema's exactly the same that you are performing a comparison against, or do the data types differ at all?

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
reval_pradeep



Joined: 11 Jul 2011
Posts: 3

PostPosted: Wed Jul 13, 2011 2:07 pm    Post subject: Reply with quote

thanks for your valuable reply,

The Schema was identical but collation was different between SQL_Latin1_General_CP1_CI_AS and Arabic_100_CI_AS in that 2 tables.

Pradeep
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Jul 14, 2011 7:48 pm    Post subject: Reply with quote

Ok, well this is probably down to the difference in collation, however it's very difficult to say for sure without copies of your DB's as it looks to be a data specific problem around casting.

Are you able to send these across?
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group