-1

hi I want to write a file into a column of a blob data type,can some one pls send me the syntax for it. Appreciate if you could also send me the syntax for retrieving the file while doing the select as well.Thanks.

Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
user274596
  • 1
  • 1
  • We need more information. Is the content of the entire file going into a single blob? Is there one file only, or several files? – Trevoke Feb 16 '10 at 18:07

1 Answers1

1

Look for the readtext and writetext functions :

writetext permits non-logged, interactive updating of an existing text or image column

readtext reads text and image values, starting from a specified offset and reading a specified number of bytes or characters

gd047
  • 29,749
  • 18
  • 107
  • 146