Decoding BLOB Data Stored as Binary in MySQL (CSENTRY Application)

[bioams]

Hi all,

I have a question regarding decoding a BLOB field (named "questionnaire") that is stored as binary data in a MySQL database. This BLOB data is created during the synchronization process in the CSENTRY application.

Can anyone guide me on how to decode this binary BLOB data or explain the process involved?

Thanks in advance!

[justinlakier]

Hello,

See this forum post on BLOB cases in the questionnaire column (viewtopic.php?t=5195) for details on how to view a case using MySQL Workbench with a query. See this forum post on syncing with BLOBs (viewtopic.php?t=2389), particularly Greg's link at the end with the steps on how to break out the cases to MySQL tables. These should help you decode/break out your BLOBs.

Hope this helps,
Justin

[bioams]

Thank You , Justin