Hello
I've got some trouble with image column under sybase 11.9.x and dblib

I have : create table test(id int, blob IMAGE);
and INSERT INTO test VALUES(1, NULL);

First, if I try to write blob column with dbwritetext
something like:
....
dbcmd(..., "SELECT blob FROM test WHERE id=1");
dbwritetext(....); // send to me erro : msg 156,
level 15, ... "incorrect syntax near the keywork NULL"

So is it possible to write an image column which is NULL. ??


Finally I succeed in changing my "INSERT ... NULL" to INSERT INTO test
VALUES(1, 0x00);
and I write 2mo in my blob...

cool
But if I try now to re-read my image column with dbreadtext()
I just read ONLY the first 32768 bytes.

Sybase documentation says "An application that retrieves image values larger
than 32768 bytes will need to call dbsetopt..."
Right but How can I set DBTEXTSIZE if I don't know the real size of my blob
column I wanna read ??


Could you help me guys ??


anyway thanx...

On Fri, 27 Aug 2004 16:12:48 +0200, Sam wrote:

You can get that information via a "select datalength(image_col)", or just
set it to the largest possible value that you might retrieve.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html