Post reply

Table with images

  • January 20, 2009 at 11:30 pm

    #204396

    hi, i have just started using SQL SERVER 2005. i wanna create a table containing Images. so which data type should i use so that if i try to access the table through .net 2005,no problem should occur. plz help

  • January 20, 2009 at 11:43 pm

    #930122

    i suggest to save the dir path of the image not the image itself.

  • January 21, 2009 at 1:17 am

    #930153

    I agree with Rio. From the application, copy the actual image to a folder and write this path into your table.

    If you want to save the images to the table itself, i suggest you read BOL and related articles first.

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ef5e4d7e-99d9-493e-98e1-52120ef735a0.htm


    Pradeep Singh

  • January 21, 2009 at 5:15 am

    #930224

    ya i have done d same i took image as data type n insertes the path of image n was successful.

  • January 21, 2009 at 5:18 am

    #930229

    or Upgrade to 2008 and use the FILESTREAM datatype..

  • January 21, 2009 at 1:12 pm

    #930662

    I'm for saving the filename in the db- as you can search the text. Not to mention the bloat that images have been known to do

    Director of Transmogrification Services

  • January 21, 2009 at 7:46 pm

    #930847

    save the path, file name and ext in diff column if you want to search the FN

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

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