[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Storing XML files into Database (MSSQL)

• To: "- -" <kerroppa@h...>,"xml-dev" <xml-dev@l...>
• Subject: Re: Storing XML files into Database (MSSQL)
• From: "Dare Obasanjo" <kpako@y...>
• Date: Sat, 19 Jan 2002 03:29:05 -0800
• References: <F911DHstgNogS4MVIGc00022f18@h...>

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

        http://www.25hoursaday.com/StoringAndQueryingXML.html

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


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/
xml07162001.asp

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.

--
THINGS TO DO IF I BECOME AN EVIL OVERLORD #49
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@h...>
To: <xml-dev@l...>
Sent: Saturday, January 19, 2002 12:10 AM
Subject:  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

• References:
  • Storing XML files into Database (MSSQL)
    • From: "- -" <kerroppa@h...>

• Prev by Date: Storing XML files into Database (MSSQL)
• Next by Date: Re: The task to be solved by RDDL. Re: RDDL (was RE: Negotiate Out The Noise)
• Previous by thread: Storing XML files into Database (MSSQL)
• Next by thread: RE: Storing XML files into Database (MSSQL)
• Index(es):
  • Date
  • Thread