birt Problem with json_unquote with mysql

0
votes

When i am trying to display the results with json_unquote its showing HEX numbers in the birt. This is the output when i tried it from workbench

This is the output when i tried it from Eclipse birt reporting

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

1
javamysqlbirt
This is not related to birt. Please show (in text, no pictures) the definition of your table, and some sample data see minimal reproducible example. - Luuk
I added the DB script and RptDesign also attached - user3309305

1 Answers

0
votes
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);