Support for JSON Datatype

Heidi currently does not support the new JSON datatype introduced in MySQL 5.7.

Problems with tables using the JSON datatype:

• The table editor cannot handle tables with these datatypes (datatype selection is empty and create table code is invalid)
• data grid shows many "dots" inside the field data, maybe because the JSON datatype is always in the utf8mb4 charset

See: https://dev.mysql.com/doc/refman/5.7/en/json.html

Please update to the latest build - that should give you JSON support. See also:

• http://www.heidisql.com/forum.php?t=19870
• r5010

I hate to bother, but it seems there are still some issues:

MySQL and PHPMyAdmin clearly shows JSON datatype for some rows:

But Heidi ( installed latest version 5minutes ago ) shows varchar for the same rows:

Is there anything I need to add/change to be able to see and edit those fields successfully?

Did you update HeidiSQL to the latest build?

I'm sorry, I didn't thought it needed additional updates after a fresh install. It now shows JSON after build update.