CAST AS NVARCHAR(0) error

emessengeremessenger Posts: 2
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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 DonahueBrian Donahue Posts: 6,590 New member
    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.
Sign In or Register to comment.