Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    2

    Question Help me design a db

    i want to design a db through which i can dynamically upload images and videos .im plannin to do it microsoft sql server 2005 and the db will be communicating with asp.net.
    also suggest me which metod would be easy and best for doin it I.E
    1)storin the images and videos in the db
    2) storin the images and videos in the folder and havin the url saved in the db

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by mihir160489 View Post
    which metod would be easy and best
    that would be 2)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2010
    Posts
    2
    what field do i need to have for that in my table and what is BLOB what is its use?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by mihir160489 View Post
    what field do i need to have for that in my table
    a VARCHAR for the path to the directory on your file server where the images/videos are stored


    Quote Originally Posted by mihir160489 View Post
    and what is BLOB what is its use?
    binary large object, used to store binary data like images/videos
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •