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