XML Character length

In SQL Server I know that varchar(max) is @8000 characters.

What is the max for XML output?

And is there a link that shows me all character type max lengths?
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
derekkrommCommented:
http://msdn.microsoft.com/en-us/library/ms187752.aspx

You'll have to click each type to get more info.

XML can hold up to 2GB.

0
 
Umar Topia.Net Full Stack DeveloperCommented:
Please refer this lnk:-
http://stackoverflow.com/questions/2742651/xml-output-is-truncated-in-sql

It has suggeted that, your Management Studio will truncate the XML once it crosses 2MB, but if you use it from C# code, you should be able to get the bigger XML data without truncation
0
 
Larry Bristersr. DeveloperAuthor Commented:
Hey guys...and the select statement in SQL?
0
 
Larry Bristersr. DeveloperAuthor Commented:
Hey guys...sorry about the question...wrong thread.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
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.