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] save XML into database

[ Lists Home | Date Index | Thread Index ]

* Michael Rys <mrys@microsoft.com> [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@engrm.com - http://engrm.com/blogometer/


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

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