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

Re: save XML into database

• To: Michael Rys <mrys@m...>
• Subject: Re: save XML into database
• From: Alan Gutierrez <alan-xml-dev@e...>
• Date: Sat, 29 Oct 2005 00:10:47 -0400
• Cc: Ken North <kennorth@s...>, xml-dev@l...
• In-reply-to: <BAE415CEAA831548800F68C44E905AF503A342E5@R...>
• Mail-followup-to: Michael Rys <mrys@m...>,Ken North <kennorth@s...>, xml-dev@l...
• References: <BAE415CEAA831548800F68C44E905AF503A342E5@R...>
• User-agent: Mutt/1.4.1i

* Michael Rys <mrys@m...> [2005-10-28 23:22]:
> Well, the problem is that often if the XML data comes from another
> provider, you do not know what code page you need to use without looking
> at the data (which you want to avoid). And storing different documents
> of different encodings is problematic at best if you are using the
> notion of a code page and a string type. If you however use a binary
> type then the encoding of the XML is preserved and you do not get into a
> code-page issue and an XML parser will be happy. Obviously similar
> things can be said about using an XML datatype (which most likely will
> use either UTF-8 or UTF-16 as internal encoding).
> 
> Using different XML Schemas is less of a problem with concepts such as
> the XML Schema collections that are currently supported in SQL Server
> 2005 and are also part of the upcoming SQL standard...

    Has anyone suggested saving to the file system, and just using
    an SQL database as index? It makes it easier to manipulate the
    collection with XSLT. It's what I do.

    Just wondering.

--
Alan Gutierrez - alan@e... - http://engrm.com/blogometer/

• Follow-Ups:
  • RE: save XML into database
    • From: "Michael Kay" <mike@s...>

• References:
  • RE: save XML into database
    • From: "Michael Rys" <mrys@m...>

• Prev by Date: RE: Use of UTF-8 and UTF-16
• Next by Date: RE: save XML into database
• Previous by thread: RE: save XML into database
• Next by thread: RE: save XML into database
• Index(es):
  • Date
  • Thread