I am trying to query a MySQL RDS Database using Query JDBC assertion, but the result i get is in BLOB(binary) format.
i even tried CASTING it with following query:
SELECT CAST(<column_Name> AS CHAR(10000) CHARACTER SET utf8) FROM <table_name>;
but the result i get from this is in unreadable format.
please advice on how to query such rows.