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?
请先登录再写评论。
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