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

Disable Download Of Binary Data?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Disable Download Of Binary Data?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 4, 2006 at 2:29 pm #9940
      Darklight
      Member

      maybe there is already a way to do this, but I've looked through all options and searched the forums and couldn't find anything.

      is there a way to turn off the download of binary data in the “Table Data” tab? when one lists a table with large files in each row, it takes quite a while to finally see data in the window. a better way would be to only see the binary data when one double-clicks the BLOB field.

      i guess a checkbox under Preferences to turn this on/off would be nice.

      that's the only feature for me that's missing from this great program! thanks to the developers!

    • October 4, 2006 at 3:56 pm #22703
      peterlaursen
      Participant

      There is no such option!

      What is your default LIMIT setting? but well .. a couple a 4 GB LONGBLOBS could be 'funny' 🙁

      A reasonable proposal, I think, but TEXT (it is not binary!) and BLOB are equally problematic, whereas a BINARY or VARBINARY type is similar to a CHAR and VARCHAR(up tp 255). And even a lot of 64 KB varchars of MySQL 5 can be equally 'funny'. As of MySQL 5 a VARCHAR, a TEXT and a BLOB are all up to 64 KB.

      We will discuss if it is possible to turn of BLOBS, MEDIUMBLOBS and LONGBLOBS (and similar TEXTS)

      A workaround is to set LIMIT = 0 in preferences and use the RESULT tab.

    • October 5, 2006 at 2:31 pm #22704
      Darklight
      Member

      yes, tables with mediumblob and longblob fields are what i meant. thanks for the reply!

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