Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

Buseen52's profile image Buseen52 posted 3 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).

Buseen52's profile image Buseen52 posted 3 years ago Permalink

The forum cropped the code, which was

xml version="1.0" encoding="utf8"

with surrounding "< ?" and "? >".

Code modification/commit c75054b from ansgarbecker, 3 years ago, revision 5157
Fix typos in encoding of xml exports. See https://www.heidisql.com/forum.php?t=23421
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 3 years ago Permalink

Should be fixed in r5157

kalvaro's profile image kalvaro posted 3 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 3 years ago Permalink

Fixed that. Encoding < and > is critical in a forum, for bad bots or users which insert something like <script>do_bad_stuff();</script> 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 3 years ago Permalink

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

ansgar's profile image ansgar posted 3 years ago Permalink

Got it now. Hopefully :)

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

:)

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