NVarChar data type

Tue, 10 Nov 2009 07:30:07 -0700

Foloowing code works perfectrly in VB.NET. However, when I tried to use it as VBScript with Integration Services, I got Error message 'String or binary data would be truncated. The statement has been terminated'. It is about NVarChar data type (see blue line of code).

SQL Server 2008 Parameter

@Body NVARCHAR(MAX)

 
 Dim cmdInsert = New SqlClient.SqlCommand("usp_INSERT_UPDATE_ARTICLE_DA
TA_MIGRATION", insertConn)
            cmdInsert.CommandType = CommandType.StoredProcedure

            cmdInsert.Parameters.Add("@Title", SqlDbType.VarChar, 4000).Value = "testing"
            cmdInsert.Parameters.Add("@Body", SqlDbType.NVarChar).Value = stringAdd
            cmdInsert.Parameters.Add("@ArticleDate", SqlDbType.DateTime).Value = Now()

            cmdInsert.ExecuteNonQuery()

            cmdInsert.Dispose()
Any idea how to fix this problem? Again it is about Integration Services VBScript task

Re: NVarChar data type

Thu, 12 Nov 2009 07:41:32 -0700

Never mind. It fixed.

Re: NVarChar data type

Thu, 25 Mar 2010 13:51:43 -0700

Have you tried explicitly specifying the max in your parameter declaration?

@Body nvarchar(4000)

I had an issue with this datatype being declared as "MAX" because of a legacy issue.

'NVarChar data type' Thread RSS Feed

NVarChar data type

Re: NVarChar data type

Re: NVarChar data type