Bug: XML export grid rows typo for UTF-8 encoding

[expired user #10573]'s profile image [expired user #10573] posted 7 years ago in General Permalink

I'm exporting the results grid of a query run on a MSSQL table, and I've chosen the XML format, with UTF-8 encoding.

But the resulting file has an invalid XML declaration:

<?xml version="1.0" encoding="utf8"?>

which fails any XML validation, because it's missing the hyphen from "UTF-8" (I prefer it capitalized).

[expired user #10573]'s profile image [expired user #10573] posted 7 years ago Permalink

The forum cropped the code, which was

xml version="1.0" encoding="utf8"

with surrounding "&lt; ?" and "? >".

Code modification/commit c75054b from ansgarbecker, 7 years ago, revision 9.4.0.5157
Fix typos in encoding of xml exports. See https://www.heidisql.com/forum.php?t=23421
ansgar's profile image ansgar posted 7 years ago Permalink

Should be fixed in r5157

kalvaro's profile image kalvaro posted 7 years ago Permalink

The forum cropped the code

@ansgar, the forum's "Source code" button doesn't seem to cope with angle brackets:

<xml version="1.0" encoding="utf8">
ansgar's profile image ansgar posted 7 years ago Permalink

Fixed that. Encoding &lt; and > is critical in a forum, for bad bots or users which insert something like &lt;script&gt;do_bad_stuff();&lt;/script&gt; here. But I found a way to leave angle bracktes only in <code> blocks, while encoding them in all other places.

ansgar's profile image ansgar posted 7 years ago Permalink

Oh shit, now the quotings don't look as wanted. Sigh...

ansgar's profile image ansgar posted 7 years ago Permalink

Got it now. Hopefully :)

kalvaro's profile image kalvaro posted 7 years ago Permalink
<:-"

:)

Please login to leave a reply, or register at first.