ASE Sybase BLOB

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.

---

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