Re: How to write UTF-8 encoded XML data to XML column?

In the absence of any response, how can I file this as a potential fault with the JDBC driver?

It appears that there may be 2 faults:

1) The exception "XML parsing: line 1, character 38, unable to switch the encoding" when writing UTF-8 data to the database using prepared statements.

2) XML documents with no BOM and no explicit encoding is being treated differently than documents with an explicit encoding of UTF-8. (This is inferred since data with an explicit encoding fails and data with no encoding succeeds).
Michael Rhys covers a similar issue in his posting "Heads up on upcoming change to passing UTF-16 encoded XML via SNCLI and ADO.Net" on microsoft.private.sqlserver2005.xml.

Regards
Nigel

Nigel Charman wrote:
I am having trouble writing XML data to an XML column using a PreparedStatement, when the XML data contains the XML declaration
<?xml version="1.0" encoding="UTF-8"?>.

.

Relevant Pages

  • Re: Want Input boxes to accept unicode strings on Standard Window
    ... If ther encoding is not specified, then the encoding is assumed to be ... Ah, UTF-8. ... That would be wrong according to the standard. ... when producing XML files. ...
    (microsoft.public.vc.mfc)
  • Re: tDOM doesnt support encoding=ASCII?
    ... a Tcl channel then Tcl will ... specifically asked for binary encoding), so any XML encoding declaration ... but when tdom sees it it is almost certainly UTF-8. ...
    (comp.lang.tcl)
  • RE: SP1 Problem SOAPException doesnt return quote and Umlaute correcty
    ... I suspect that there is an encoding issue in the way you are loading the ... Is there an inconsistency between the XML encoding mark up and the ... Found out .net web service clients are just as helpless with handling these ... If an exception is raised in the web service method saying i.e. 'The method ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: XML files with bad characters
    ... This looks like an encoding problem. ... What is the encoding that you use in DTS and in the database? ... If you for example have no encoding specified in the XML declaration (or no ... >using IE that don't have the either of these two invalid characters. ...
    (microsoft.public.sqlserver.xml)
  • Re: Encoding XML troubles
    ... > I am using the WebRequest functionality to get the feeds. ... > default) already define the encoding type of the expected stream. ... as I do not now the encoding type while fetching the xml ... > xml string, get the encoding type and re-encode result string with the ...
    (microsoft.public.dotnet.languages.csharp)
Loading