Post reply

Image

  • August 4, 2003 at 2:35 pm

    #159535

    How can I store an imgage(.Jpg or .bmp file)in my sql server table.Which datatype i should use and how can store it in my database table.

    Thanks in advance.

  • August 4, 2003 at 3:25 pm

    #468544

    I used the image data type for my simple web page.

  • August 5, 2003 at 2:15 am

    #468582

    If you use a binary large object (BLOB) you can stream the images in/out as you please.

    It all depends on the size of your images.. e.t.c

    But that gets you on to the old chesnut if is it better to store them in the database or on the filesystem????????

    This has been discussed many times before.....

  • August 5, 2003 at 2:42 am

    #468589

    quote:

    If you use a binary large object (BLOB) you can stream the images in/out as you please.

    It all depends on the size of your images.. e.t.c

    But that gets you on to the old chesnut if is it better to store them in the database or on the filesystem????????

    This has been discussed many times before.....

    that's right!

    It's best to get a solid understanding what storing binary data in tables means and implies.

    The best source I've come around on this topic can be read here:

    http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 5, 2003 at 11:43 am

    #468707

    Don't do it ! You will regret it due to space concerns and no ability to compare the image type.

    Put the image in a bcked up directory and dtore the path to the image in the database.

  • August 8, 2003 at 8:26 am

    #469191

    hey whats dtore, can u please explain me in detail.

    Thanks

  • August 12, 2003 at 6:29 pm

    #469660

    I am guessing but dtore = store.

    I used to think storing the path was the was to go, but with what I have been reading about the future of windows and SQL server I would store the BLOBs in the DB now.

    I do sugest creating a seperate file group for the blobs.

  • August 13, 2003 at 12:11 am

    #469676

    I've made good experience storing BLOB's in a total separate db, which stores nothing else.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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