How to specify data type for a table column that receives file(document) on sql

Discussion in 'SQL Server' started by justiceegbo555, Aug 4, 2010.

  1. justiceegbo555

    justiceegbo555 New Member

    Joined:
    Aug 4, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Please i want my users to upload a file(doc) maybe like cv's and i want it to save on sql but i don't know how to specify the data type for the column that recives this files(doc) please i need help possibly to my email address or jst reply here....thanks
     
  2. sql-programs

    sql-programs New Member

    Joined:
    Oct 21, 2009
    Messages:
    14
    Likes Received:
    2
    Trophy Points:
    0
    Occupation:
    Software Developer
    Home Page:
    http://www.sql-programmers.com
    Use bellow data type to store Document and picture types of data.

    VARBINARY(MAX)
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice