I need to store some xml into a database as sting. The xml is needed for future processing of the extracted text but doesnt play any role in selection/update/delete process e.g. I want the text to contain various nodes but for the select/ update/ delete sections to be able to just ignore them. Is this at all possible and if so what databases support this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
xml in databases
- Thread starter Naug
- Start date
Yes, this is entirely possible. XML is just a string anyway, so you can store it in any database. Some relational databases, such as the newer versions of SQL server, allow you to store data as XML (not just a string, but actual nodes). There are also a lot of native XML databases.
- Thread starter
- #3
- Status