Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Very long bytea fields

nafex
2013-09-06
2013-09-11
  • nafex
    nafex
    2013-09-06

    Is it possible to limit the showing text length from bytea fields? I have some images base64 encoded in my PostgreSQL database and they are shown in one big line...

    Thank you very much

     
  • nafex
    nafex
    2013-09-06

    here an image how it looks

     
    Attachments
    • Jan78
      Jan78
      2013-09-10

      I have a similar problem with a longblob column. i.e. table with the following fields:

      attachment_id bigint(20) unsigned Auto Increment
      name varchar(255)
      filename varchar(255)
      comment varchar(255)
      group_name varchar(255)
      group_id int(10) unsigned
      content_type varchar(32) NULL
      data longblob NULL

      I inserted several files(attachments) in to the attachment table, but
      I cannot list rows from the table. I'm able to see only the first row
      (up to data column..., which is empty)

      The adminer generates the following html code:

      ....
      onclick="selectClick(this, event, 0);">3application/pdf

      It seems that Adminer has a serious problem with displaying a long data rows. Usually
      the 'data' field contains 2-10MB of raw data.

      Do you know how to solve it? PHPMysqlAdmin displays several chars from each file,
      and continues on the next row...

      Jan

       
      • nafex
        nafex
        2013-09-11

        no, I don't know how to solve it. I think the only way is that Jakub Vrána changes the code...