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

Re: save XML into database

• To: <xml-dev@l...>
• Subject: Re: save XML into database
• From: "Ken North" <kennorth@s...>
• Date: Fri, 28 Oct 2005 13:43:31 -0700
• References: <BAE415CEAA831548800F68C44E905AF503A33CC2@R...>

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

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

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