Database tool: Show hex for small BLOB fields

Answered
Avatar
Nathan Palmer
Created

I have recently updated to IntelliJ IDEA 2017.2.5. (I upgraded from 2016.?, so I had skipped over a few updates)

I am using MySQL and storing UUIDs into a binary(16) field. Until this recent update, when browsing the tables using the database tool, I was able to see the hexadecimal value of the BLOB field. All I am able to see now is the unreadable gibberish of text.

I can't seem to find any options to re-enable the hexadecimal display. Was this feature removed? Or am I truly blind and can't find the option to enable it?

Thanks for any suggestions!

Votes

1

Share

3 comments
Avatar
Yaroslav Bedrov
Created

Is it possible to get idea.log ("Help | Show Log in...") from previous version? Looks like this feature hasn't been integrated yet: https://youtrack.jetbrains.com/issue/DBE-4721

0
Avatar
Nathan Palmer
Created

I finally found the version I upgraded from: 2017.1.2

I have re-installed it, and here is an example of it:

-- Create MySQL table and insert data --
CREATE TABLE testing (ID BINARY(16) NOT NULL PRIMARY KEY);
insert into testing VALUE (x'00112233445566778899aabbccddeeff');


This is what it looks like in 2017.1.2:

This is what it looks like in 2017.2.5:

 

Yaroslav, how would you like me to send you the file? I would rather not post that file publicly.

0
Avatar
Andrey Dernov
Created

Hello Nathan, Thanks for details. This is fixed in the 2017.3 version: https://youtrack.jetbrains.com/issue/DBE-5104

EAP is available at https://www.jetbrains.com/idea/nextversion (can be installed and run along with 2017.2 version).

0

Please sign in to leave a comment.