Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW DO I INSERT A JPG FILE IN SQL SERVER IMAGE DATATYPE COLUMN
- Thread starter 2314
- Start date
Sorry I can't help you on this....I have never looked into exactly how that would be done. (I'm sure others will respond with a solution, though.)
But I did want to mention that what you are trying to do is typically not recommended.....it bloats the database, and some client technologies are unable to deal with the blob datatypes. What is usually suggested is to store the images outside the database in a directory on the hard drive, controlled by the operating system. In SQL Server, you then use a varchar column to contain a reference to where the image(s) is stored. i.e. this column might have a value of 'c:\assets\images\tractor.jpg'.
My apologies again for not being to help with your specific question.
bp
But I did want to mention that what you are trying to do is typically not recommended.....it bloats the database, and some client technologies are unable to deal with the blob datatypes. What is usually suggested is to store the images outside the database in a directory on the hard drive, controlled by the operating system. In SQL Server, you then use a varchar column to contain a reference to where the image(s) is stored. i.e. this column might have a value of 'c:\assets\images\tractor.jpg'.
My apologies again for not being to help with your specific question.
bp
- Status
Similar threads
- Locked
- Question
- Locked
- Question