Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Format binary column in data grid

I'd like to see a way to make the data grid display all values for a specific columns (in this case, a binary(16)) as a GUID.

Right now I have to create a view for each table and I would prefer it to be more efficient.

This could be solved in a robust and efficient way by allowing the user to apply a function of their choosing to the column. That's really all I'm doing in the view.

7 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Tom Wesson shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • digiflex commented  ·   ·  Report

    We store other little things as binary, and it would be great to say "show as hex" rather than as gibberish, not least because the char values are often non-printing characters that do ugly things when copy'n'pasted.

  • Kevin commented  ·   ·  Report

    I would like to see this as well. We use varbinary(16) to represent 32 character UUIDs (with no dashes) for things like primary keys and id fields.

    Having the data grid automatically HEX() the value on read and UNHEX() on save would be a great feature to have. In other words, it would be nice to be able to see the hex UUID in the cells rather than a bunch of garbled characters.