freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: LacaK <lacak AT zoznam.sk>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] HOW TO insert binary data into IMAGE column using db-lib
Date: Mon, 03 Oct 2011 12:59:09 +0200

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.

Re: [freetds] HOW TO insert binary data into IMAGE column using db-lib, LacaK, 10/03/2011