[
Lists Home |
Date Index |
Thread Index
]
RE: [xml-dev] 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
|
