General information
Forum:
Microsoft SQL Server
Title:
Storing Word docs- working with binary, how?
HI:
I would like to be able to store Word documents in SQL Server. Since Word uses binary format, the SQL Server docs say to use an Image field.
Currently, my VFP client uses Word automation to allow creation and editing of RTF docs. Using RTF, it is simple matter to open file and insert text into SQL string and send to database. This has been working well for a number of years, but RTF format can result in very large files if there are graphics.
Switching to Word would be more efficient. How do you work with binary data? Can it be inserted into a SQL string? What options are available for searching an Image field for substrings?
Thanx,
Charlie
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only