CAST AS NVARCHAR(0) error
emessenger
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.
[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
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.
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.