PavelVD posted
Hello. IN 12 version we have problem with encoding BLOB columns. If we have table
id AI PL value_json longblob value_str varchar in charset cp1251
And insert there UTF charset - we have problem in Heidi:
in console command if we run
set names utf8;
select * from <table>
We will see correct UTF values for all columns
In heidiSQL if we will run set names utf8; select * from <table>
We will see correct values only for value_str column , but wrong charset in value_json columns.
Checked on many tables - problem only with blob columns.