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

base64_decode images

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › base64_decode images

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • June 13, 2005 at 12:50 pm #18160
      Ritesh
      Member

      You can directly store images in MySQL. You have to use either blob, mediumblob or longblob datatype to store images. SQLyog provides you with a GUI to work with images.

    • June 13, 2005 at 5:29 pm #18161
      Anonymous
      Guest

      I use longtext and base64….

      would using longblob be equivilent to using longtext and base64 ? or whats the difference or whats better. And with images out of a database, is there a way to make the browser cache it. my site is http://deadlydesigns.net and all the avatars for each tutorial are stored in the DB and I am not sure if it is being cached.

    • June 13, 2005 at 5:43 pm #18162
      peterlaursen
      Participant

      the difference of the “text” types and the “BLOB” types are that “text” only accepts character-input, BLOB accepts all (Binary) inputs.

      As I read from here: http://www.fourmilab.ch/webtools/base64/ base 64 was created to allow transmision of binary data by email. I can't see any idea in transforming binary data to charcater data in order to store it in a database.

    • June 13, 2005 at 6:06 pm #18163
      Anonymous
      Guest

      Good to know thanx…

      PHP.net says that base64_decode takes ~33% space also. So I just might change to longblob for my images.

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