adExecuteStream and navarchar(4000) ?

Can anyone explain this ?
In SQL Server 2000 books online there is an example under
topic XML called Sample Visual Basic Application  To Update Records Using OPENXML And ADO.

Now VB helps says using adExecuteStream allows you up to
about 2GB of data, as does the Visual Basic type String.

However, the example shows a stored procedure with a parameter of nvarchar(4000), which is used to pass in the XML .
The VB code for the example uses adExecuteStream. But
what happens if the XML is longer than nvarchar(4000) ?
Surely the example is flawed ?
josereyesAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
The example is NOT flawed, as NVARCHAR has a max size of 4000. If you want to store more data, you need to use the TEXT datatype (without size, able to store up to 2GB of data).

CHeers
0
 
CleanupPingCommented:
josereyes:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.