XML input getting truncated

Question

I have an xml doc (size: 3.59 mb) with 3765815 total characters in it. My sql server 2008 database table has a column with xml data type. When I try to insert this xml into the column it seems to truncate it.

I thought xml data type can handle 2GB of data. Is this a correct understanding or am i missing something?

Thanks

Here is the query i am using

declare printxml nvarchar(max) 

select printxml=cast(inputxml as varchar(max))
from TableA
where SomeKey='<some key>'

print printxml

yes. i am trying to view in management studio. it truncates to 4002 characters. When i try to open the xml text in the column in management studio it says xml not well formed. I did declare a variable and print the variable and it was truncated to 4002 characters. — stackoverflowuser
– stackoverflowuser, Commented Jun 23, 2011 at 1:01

Jon Seigel · Accepted Answer · 2011-06-23 01:21:55Z

4

Select the data directly instead of printing it to the messages window:

SELECT
    inputxml
    FROM TableA
    WHERE SomeKey = '<somekey>'

The caveat is that you have to set up Management Studio to be able to return all the data to the window. You do that using the following option (the default setting is 2MB):

answered Jun 23, 2011 at 1:21

Jon Seigel

12.5k8 gold badges61 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

XML input getting truncated

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related