Skip to Content.
Sympa Menu

freetds - Re: 255 char limit in result queries

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 255 char limit in result queries
  • Date: Thu, 2 Nov 2000 08:07:23 -0500 (EST)


Hmmm...try:

set textsize 65536

before issuing your query and see if that helps, adjust the number if
your textfields are larger than 64k.

Brian

On Thu, 2 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> i run the freetds snapshot from the freetds.com site (which is v0.5 i
> think). the query we run is:
> $r1=mssql_query("Select dbo.SUPPORTPROJECT.Proj_toel,
> dbo.SUPPORTPROJECT.Proj_antwoord FROM dbo.SUPPORTPROJECT Where
> (Proj_nr=$pn)");
> the proj_toel and proj_antwoord fields are both textfields in the database
> that can be several KB long. the same query run on an NT box (odbc_do(.))
> gives the full result so i know the fields are filled. the version mssql
> server is 6.5...
> i suspect freetds to be the one failing in this. perhaps i should try to get
> an odbc client running on the linuxbox but i'd rather use freetds so i'd
> very much like to have this solved.
>
> -----Original Message-----
> From: Mark Schaal [mailto:mark AT champ.tstonramp.com]
> Sent: woensdag 1 november 2000 19:58
> To: TDS Development Groupn
> Subject: [freetds] Re: 255 char limit in result queries
>
>
>
> I wasn't able to reproduce this here under TDS4.2/MSSQL7.0. I'm not
> sure we have a MSSQL6.5 machine around anymore.
>
> Are you running a recent freetds version from the CVS repository?
> If not, please try that first as it has numerous improvements over
> the released version.
>
> If you could post a simple test case of the SQL statements you run
> which fail, I'd be glad to run it here.
>
> Mark
> --
> Mark J. Schaal Phone: (909)
> 620-7724
> TST On Ramp Fax: (909) 620-8174
> System Administrator E-Mail: mark AT tstonramp.com
>
> ---
> You are currently subscribed to freetds as: [H.vanBrug AT syntegra.nl]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
> -----------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from any
> computer.
> -----------------------------
> Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder
> Syntegra goederen en diensten levert zijn met uitsluiting van alle andere
> voorwaarden onze algemene voorwaarden van toepassing. Deze worden u op
> aanvraag direct kosteloos toegezonden. Tevens kunt u deze vinden via onze
> homepage http://www.syntegra.nl
> -----------------------------
> On all offers and agreements under which Syntegra supplies goods or services
> of whatever nature, the general terms and conditions from Syntegra Groep
> B.V. exclusively apply. The general terms and conditions shall be promptly
> submitted to you on your request. You can also find these via our homepage
> http://www.syntegra.nl
> -----------------------------
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page