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

CAST AS NVARCHAR(0) error

Using SQL DATA COMPARE 5.2.0.40 trying to synch sql_variant data, and i get this error:


[1001] Line 92: Length or precision specification 0 is invalid.
Line 94: Length or precision specification 0 is invalid.

Here is the line of code...

UPDATE [dbo].[ShapeAttributeValue] SET [Value]=CAST(N'' AS nvarchar(0)) COLLATE SQL_Latin1_General_CP1_CI_AS WHERE [ShapeId]=28845 AND [AttributeID]=107

I think its trying to cast a null or empty space to be a NVARCHAR(0), which isn't allowed. Any advice would be great.
emessenger
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi Eric,

    I think this is a bug. We are going to look into it and email you back at the below address. I can see how the program would cast an empty column as nvarchar(0), so we should probably throw in a conditional statement into the code to prevent this.
    Brian Donahue
    0
  • Brian Donahue
    Hello,

    Can you please tell us if the SQL server is SQL Server 2000, 2005, and what kind of data is in the variant column?

    Thanks.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.