Show mediumblob as text?

In a database that I use often, long text is put in mediumblob. :(

I think everything else I have used including the command line has shown me the text, but HeidiSQL shows me hex.

Is there any way that I can see text here?
Is there a preference that I have overlooked?

My current work-around is to do this: CAST(raw_message AS char). It works, but it a pain.

Thanks!

You can click the "View binary data as text (instead of HEX)" toolbar button.

Again, I have fallen victim to "feature is in a button but not in the menu" design!

Thanks. I've gone a couple of years using MariaDB without figuring this out myself.

Well, you're not the first one wondering about that. So, r5109 is for you (and some others): This adds a new submenu in the context menu of the data grid, labelled Grid view options and showing the following partly new menu items:

• ...
• Save BLOB to textfile
• Grid view options
• This is a UNIX timestamp column
• Image preview
• View binary data as text
• Data grid preferences
• ...

Thank you for taking pity on people like me!

I will make a donation soon... Thanks for all your great work.