Store XML?

Last Post 31 Jul 2008 01:56 PM by ufohj. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ufohj
New Member
New Member

--
31 Jul 2008 11:41 AM
What type of data field is better to store XML? BLOB, text, or VARCHAR fields?
I'm using text now.
If I want to store it in BLOB, how to convert to BLOB? Can someone show me an example?

Thanks.

ufohj
New Member
New Member

--
31 Jul 2008 01:56 PM
quote:

Originally posted by: rm
There is xml data type in sql2k5, may try text type in sql2k.



Thanks rm.
Some articles mentioned BLOB is ideal for XML.
Currently, I want to store it in BLOB in SQL2000. But we may move to SQL2005 very soon.
For xml, do you think the data type of XML in SQL2005 is better than BLOB in SQL2000/2005?

Thanks again.


Acceptable Use Policy
---