web stats
Images in blob field - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 10-19-2011, 08:16 AM
ricber ricber is offline
Mirth Guru
Join Date: Jun 2007
Location: Barcelona, Spain
Posts: 185
Default Images in blob field

Hi all,

I'm trying to recover images froma blob field in a SQLite database. Everything works great until Mirth try to generate a XML message with the results of the query. No problem with regular fields (string, integers, etc), but when blob field appears everything crashes because SQLite stored data inblob fields in binary format, and this binary format, of course, is not valid data for an XML.

At htis point I tried to convert to base64 format from database query but without success. Another time, I try to convert to base64 in preprocessor, but I don't know how to apply the encode functionexplicitly to that field, and not to the entire message.

Any hints about?, can I apply FileUtil.encode only to the field that contains binary data?

Thanks for your help,

Ricard Bernat
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 03:25 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation