ASE Sybase BLOB

Question

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.

Answer 1

Actually this is for Sybase and I dont see any relevant syntax for binary or text data type. can someone pls help.

Answer 2

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