How can we help you today? How can we help you today?

Error while data comparie

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
reval_pradeep
0

Comments

3 comments

Sort by
  • 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
    0
  • 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
    reval_pradeep
    0
  • 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
    0

Add comment

Please sign in to leave a comment.