OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] Storing XML files into Database (MSSQL)

[ Lists Home | Date Index | Thread Index ]

Short answer:
You can use the VARCHAR type in your database of choice if you are only going
to be dealing with storing and retrieving entire documents at once.

Long Answer:
If you are interested in storing and retrieving XML from databases I suggest
reading the article below


Currently MSSQL (Which I assume means SQL server) does not directly support
native storage and retrieval of XML documents but instead allows one to create
XML views of relational data which one can then load XML files to through the
XML Bulkload feature. For more on SQL Server 2000's XML features read


PS: Both the latest versions of Oracle and IBM's database products support an
XML type which can be stored in a column in a relational table. Hopefully
MSFT will get their act together and support a similar feature in the next
version [or web release] their product.

PPS: I believe Sybase also has some XML functionality in their product but
haven't tried it out yet.

If I learn the whereabouts of the one artifact which can destroy me, I
will not send all my troops out to seize it. Instead I will send them
out to seize something else and quietly put a Want-Ad in the local paper.

----- Original Message -----
From: "- -" <kerroppa@hotmail.com>
To: <xml-dev@lists.xml.org>
Sent: Saturday, January 19, 2002 12:10 AM
Subject: [xml-dev] Storing XML files into Database (MSSQL)

> Hi all,
> I just wonder how I can save XML files into database and retrieve them from
> it. When creating a column for them, what kind of datatype should I use?
> Can I just do INSERT and SELECT statements?  Are there any gacha that I need
> to worry about? BTW, I'm using MSSQL for the database.
> Thanks in advance,
> kero
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> The list archives are at http://lists.xml.org/archives/xml-dev/
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS