October 17, 2003 at 7:44 am
Can you insert images into SQL Server?
October 17, 2003 at 9:28 am
Yes. Look up BLOB, ntext, text, and image
in the Books Online.
However, depending upon your situation, it may be preferable to store a pointer to a file (fully qualified DSN) and access the file from an external location. Many document management systems function this way.
Joe Johnson
NETDIO,LLC.
Joe Johnson
NETDIO,LLC.
October 20, 2003 at 12:40 am
quote:
Can you insert images into SQL Server?
Have a look at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 20, 2003 at 3:20 am
check out "TextCopy " in BOL
October 20, 2003 at 5:05 am
hi!
for storing images (which is BINARY data) you'd use the datatype "image". text/ntext are for alphanumeric data (respectively unicode alphanumeric data).
depending on how you access your DB from client side, you'll have to check your API on how to write/read binaries to/from DB. if you're using ADO, you should check the GetChunk/AppendChunk methods (see MSDN).
best regards,
chris.
October 24, 2003 at 8:01 am
Hi,
if you're going to use ADO.NET, check out the following:
HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET - http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316887
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply