How to query jrxml text in JIFileResource.data field

[stuartu]

From what I understand with Jasper Server, when creating an iReport, the SQL is stored as a jrxml file in a MySQL longblob field JIFileResource.

When viewing this field, it is all gobbly-gook, and I was wondering if there is some way of viewing the SQL.

If I'm looking in the wrong place for the SQL generated as part of an iReport, please also advise.

[stuartu]

Ahhh,... found it:     select id, convert(data using utf8) from JIFileResource;