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

Using Pictures

forums › forums › SQLyog › Using SQLyog › Using Pictures

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 19, 2005 at 2:50 am #9061
      Cuthdu
      Member

      Hi,

      Seem to be having a problem having my pictures to show via my browser. Everything else seems to be working fine. Do you think I did not apply the right datatype for the use of graphics/pictures?

      I used the mediumblob for the graphics…

      Regards

      Cuthdu

    • June 19, 2005 at 3:54 am #18203
      peterlaursen
      Participant

      datatype mediumBLOB should be OK.

      Here http://dev.mysql.com/doc/mysql/en/storage-…quirements.html it says that that the mediumblob could store data sixes of 2 ^ 24 bytes. That is about 16 MB.

      Do you use PHP or ASP or whatever ?? Could you provide some code example, that show which method you use to fetch the data ?

      What is the purpose of your attachment ? We can't use it for two reasons:

      1) you can't copy a mySQL Datafile (a.MYD-file) like was it for instance an Access database. The MYD-file will only have meaning with the server environment where it was created.

      2) actually BLOBs are not stored within a table. Only a pointer is stored in the table. The binary data elsewhere …

    • June 19, 2005 at 4:19 am #18204
      peterlaursen
      Participant

      and …

      Does the SQLyog BLOB-viewer display the graphics correctly ?

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