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

RE: save XML into database

• To: "Ken North" <kennorth@s...>,<xml-dev@l...>
• Subject: RE: save XML into database
• From: "Michael Rys" <mrys@m...>
• Date: Fri, 28 Oct 2005 20:22:32 -0700
• Thread-index: AcXcARdBIjgVlICsSmyYtybiinZ2cQANl2mQ
• Thread-topic: save XML into database

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...

Best regards
Michael

> -----Original Message-----
> From: Ken North [mailto:kennorth@s...]
> Sent: Friday, October 28, 2005 1:44 PM
> To: xml-dev@l...
> Subject: Re:  save XML into database
> 
> RE:  save XML into databaseMichael Rys wrote:
> >> Actually a BLOB/varbinary(max) type is better suited for XML than a
> CLOB/varchar(max) type since the BLOB has no code page associated with
it
> and
> therefore does not interfere with the XML document's encoding.
> 
> Depending on your choice of data access API/driver/provider, you can
> dynamically
> set the encoding to use for characters on a per connection basis. By
> changing a
> connection property, you can override the database's default.
> 
> A related issue is storing documents of different encodings in the
same
> column.
> If the column is of type XML, we may want to use different XML schemas
for
> the
> same document (column).
> 
> ======== Ken North ===========
> www.WebServicesSummit.com
> www.SQLSummit.com
> www.GridSummit.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://www.oasis-open.org/mlmanage/index.php>

• Follow-Ups:
  • Re: save XML into database
    • From: Alan Gutierrez <alan-xml-dev@e...>

• Prev by Date: Re: Non-schema approach to web service design: comments?
• Next by Date: RE: Use of UTF-8 and UTF-16
• Previous by thread: Re: save XML into database
• Next by thread: Re: save XML into database
• Index(es):
  • Date
  • Thread