Re: HOW TO insert binary data into IMAGE column using db-lib

Hi James ,
thank you VERY MUCH for your response.

> I am unable to reproduce your problem.  Perhaps you're being fooled
> into thinking you sent only 4 KB because your TEXTSIZE is 4096?  
>   
Yes you are right, I did not used TEXTSIZE at all, but I found in 
documentation of SQL Server 2000, that 4096 is the default value.
So when I send "SET TEXTSIZE 2147483647" all works ok, IMAGE columns are 
read in full length

> I'm filing this under not-a-bug.  :-)
>   
right

> At one time, stored procedure parameters could not be of type
> text/image.  That was a server limitation and is no longer the case, at
> least with SQL Server 2008. 
also SQL Server 2000 supports IMAGE/TEXT Stored Proc. parameters

Thanks again
-Laco.