Post reply

Placing Pictures in Database?

  • May 13, 2005 at 8:23 am

    #166770

    I remember while in school using an Access DB we could "store" pictures and retrieve them. We didn't actually do this. They were already there. Is this really possible?

    With my current application i stored the ADDRESS of the picture in the cell and had the picture pulled from another location.  If this is possible to actually store the picture in the DB, please explain how this can be done. How do you add a picture to the DB?

    This also leads to the question of whether my MP3 files, AVI files, and PDF Files can be saved in the DB for retrieval purposes also.

    Thanks!

  • May 13, 2005 at 8:58 am

    #558740

    You can use the Image data type to store binary data in a database. Depending on how many binary files you have this could quickly expand the size of your sql db. Also you can store word docs in the image data type field wich allows you to search the text of those word docs with SQL

    Personally I would stick to storing the address of the file in the database

  • May 13, 2005 at 9:23 am

    #558759

    If it's a file then you can store it in a database via the image data type.

    There are loads of pro's and cons for doing it this way as opposed to just storing a link but it's a Friday afternoon here and I don't want to get into it again.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply