Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Retrieving Binary Fields

forums › forums › SQLyog › Using SQLyog › Retrieving Binary Fields

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 20, 2010 at 9:58 am #12082
      ema
      Member

      Hello!

      I opened (F11) a table containing some record. This is useful to edit some data without building 'update' commands.

      This table has a varbinary(255) field (VBF for short).

      The VBF values are not shown in the corresponding column: on their place I have the “(Binary/Image)” phrase.

      I expected to be shown the hexadecimal representation of the binary values (something like the result of mysql hex() function), so they could be modified like other fields.

      Is there a way to obtain that?

      I think it would be a good feature, since mysql client leaks too: it tries to print a textual (ascii) version of the binary values, that often don't represent printable char (what an ugliness to see ☺☻♥♦♣!)

      Thanks.

    • August 20, 2010 at 10:21 am #31263
      Shalmali
      Member

      ema,

      Thank you for your suggestion. We have already planned to improve the representation of Binary Data types in Result tab and Table data. Its scheduled to be implemented

      in the upcoming release.

      http://code.google.com/p/sqlyog/issues/detail?id=1364

      ~Shalmali

    • August 20, 2010 at 10:29 am #31264
      peterlaursen
      Participant

      There are a bunch of issues with binary types. Here is an older record from our issue-tracker:

      http://code.google.com/p/sqlyog/issues/detail?id=15

    • August 20, 2010 at 10:53 am #31265
      ema
      Member

      Thank you, everybody!

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.