locked
Inserting .doc data into varbinary column RRS feed

  • Question

  • I need to put .doc data into a varbinary column for full text searching.  I have created the db and columns but am unsure as to how to insert the varbinary data.  I have found some discussions about inserting images but nothing explicitly on .doc files.  Can anyone suggest resources or sample code?
    Saturday, August 18, 2007 8:26 PM

Answers

  • The varbinary datatype does not differentiate the contents of the field, it's all just binary data as far as SQL is concerned. The samples you've found for images should apply equally to any type of binary object, it just seems that most examples are focues on image since most people want to store image data.

     

    Mike

    Saturday, August 18, 2007 9:37 PM

All replies

  • The varbinary datatype does not differentiate the contents of the field, it's all just binary data as far as SQL is concerned. The samples you've found for images should apply equally to any type of binary object, it just seems that most examples are focues on image since most people want to store image data.

     

    Mike

    Saturday, August 18, 2007 9:37 PM
  • Thanks Mike.  I will try those examples.
    Saturday, August 18, 2007 9:56 PM