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: "Brug, Herco van -Syntegra NL" <H.vanBrug AT syntegra.nl>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 255 char limit in result queries
  • Date: Wed, 1 Nov 2000 14:48:29 +0100


i did compile freetds with tdsver 4.2 but i was under the impression that
when you put a 'putenv("TDSVER=70") in your phtml page, the version used was
7.0. i tried that and got the same result (text cut off at 255 chars). any
other way to correct this problem? i'm rebuilding freetds now and will post
what happens

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org]
Sent: maandag 30 oktober 2000 18:54
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries


> anybody aware of a problem with freetds that makes results from queries be
> cut off at 255 chars? using odbc connection it returns all pages from the
db
> but using freetds as layer it stops at 250 and some chars. is there a
patch
> or fix for this problem?
>

I'll assume you are referring to char/varchars types of > 255 in SQL
Server 7.0 being truncated to 255? The usual cause of this is that you're
using TDS 4.2 instead of TDS 7.0. Configure freetds with the
--with-tdsver=7.0 flag to correct.

Brian

---
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
-----------------------------





Archive powered by MHonArc 2.6.24.

Top of Page