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

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?