Datagrip export blob field as plain/text
Answered
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?
Please sign in to leave a comment.
The issue is known but not fixed yet. https://youtrack.jetbrains.com/issue/DBE-8676
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