birt Problem with json_unquote with mysql

Question

When i am trying to display the results with json_unquote its showing HEX numbers in the birt.

DB Script for creation of table:

CREATE TABLE action_data1 ( id_ref bigint NOT NULL, data_map text, PRIMARY KEY (id_ref) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Rptdesign was attached here

Answer 1

mysql> select json_unquote(json_extract('{"test":"abc"}','$.test')) as test;
+------+
| test |
+------+
| abc  |
+------+

It seems to work OK, so more input is needed.

EDIT:

seeing Brit return Mysql string concatenated field as a blob

you can try this:

select convert(json_unquote(json_extract(data_map,'$')),CHAR);