Yukon XML  
Author Message
swatsp0p





PostPosted: Thu Jan 22 08:17:17 CST 2004 Top

SQL Server Developer >> Yukon XML

Reading the article in MSDN magazine on Yukon XML it says the XML data type
must be converted to and from a CLOB (varchar(max) or nvarchar(max)).

Doesn't this place a somewhat severe limitation on the size of the XML data
that can
be stored as a XML data type? I haven't found anything that says the maximum
sizes of varchar and nvarchar will be increased.

Rgds
Peter Johnston

SQL Server46  
 
 
Jacco





PostPosted: Thu Jan 22 08:17:17 CST 2004 Top

SQL Server Developer >> Yukon XML Hi Peter,

varchar(max), nvarchar(max) and varbinary(max) have a storage capacity of
2GB, that same as the current text, ntext and image data types. You ahve to
use the word 'max' instead of specifying a number (like varchar(8000 for
example) to get the 2GB capacity.

--
Jacco Schalkwijk
SQL Server MVP




> Reading the article in MSDN magazine on Yukon XML it says the XML data
type
> must be converted to and from a CLOB (varchar(max) or nvarchar(max)).
>
> Doesn't this place a somewhat severe limitation on the size of the XML
data
> that can
> be stored as a XML data type? I haven't found anything that says the
maximum
> sizes of varchar and nvarchar will be increased.
>
> Rgds
> Peter Johnston
>
>


 
 
Peter





PostPosted: Thu Jan 22 08:41:17 CST 2004 Top

SQL Server Developer >> Yukon XML

> varchar(max), nvarchar(max) and varbinary(max) have a storage capacity of
> 2GB, that same as the current text, ntext and image data types. You ahve
to
> use the word 'max' instead of specifying a number (like varchar(8000 for
> example) to get the 2GB capacity.

Thanks, answers the question perfectly. Lot of good stuff in Yukon that
will be useful in what I do.

Rgds
Peter Johnston