blob column value not correct

first execute the file "create.sql"
then open the heidisql gui.
you will get the incorrect result as shown in the file "compare.txt".

heidisql version 9.3.0.5077
database: 10.1.13-MariaDB
OS: Windows

the value is correct after insert statement executed.
the value get wrong both in gui and exported statement.

Hello

I think this is due to HeidiSQL transforming blob data through some operating system part which depends on the system code page. So depending on the language of your Windows installation, such an error may or may not occur.

I reported this a while back on http://www.heidisql.com/forum.php?t=17185 and later updated my report with an easy reproducible method on non-english Windows versions here http://www.heidisql.com/forum.php?t=18313#p18786

Sadly both my posts were ignored as far as I can tell.

This is a huge problem which destroys any kind of exports or backups taken with HeidiSQL (on some non-english Windows versions). I wish it had a higher priority.

What language does your operating system run on?

zh_CN, encoding GBK
timezone: Asia/Shanghai