Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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

Archive powered by MHonArc 2.6.24.

Top of Page