Datagrip export blob field as plain/text


Hey all,

Have anyone encountered the problem with exporting a blob field (MySQL) as plain/text? Our DB schema icludes a blob field in which we store simple text that shows up correctly on the results tab (as text) but if I want to export it in any format (eg. TSV), then it gets converted to hex and I cannot preserve the format as text.

Do you know any setting which forces the export to be text and not hex for these blob fields?

Comment actions Permalink

We found that the issue is present when you do a subselect over the table to export. Try to do a select * from table and then try to export the blob field


Please sign in to leave a comment.