AnsweredAssumed Answered

How to get Readable data of a BLOB type field while querying DB

Question asked by nehasi3 on May 22, 2017
Latest reply on May 24, 2017 by nehasi3

StephaneMOLDOCH4453211 norre01 sridevi.kanchustambham layer 7 gateway jdbc query

Hi,

 

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.

 

Regards,

Neha Singh

Outcomes