Error while data comparie

[reval_pradeep]

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

[peter.peart]

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

[reval_pradeep]

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

[peter.peart]

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