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: Tue, 7 Nov 2000 09:56:05 +0100


i'm not sure how to look up the table definition (as i am not the su of the
database server). in ms-access it tells me the fields i'm looking for are of
type 'memo'.
i tried the convert(text,db.table.field) but that returns nothing. according
to my sql book this would convert a variable named 'text' to the 'field'
charactertype. i dont think my book is right because if i try to convert it
to something else but 'text', the server tells me that's not a correct
datatype.

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org]
Sent: vrijdag 3 november 2000 15:21
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries




On Fri, 3 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> ok after some trial and error i set it with mssql_query("set textsize
> 10000\nSelect * from something");
> this still limited the result to 255 chars. setting it to 10 (!) did limit
> it to 10 chars so the thing works but only to make it smaller, not bigger
> than 255 chars.......
> the field i'm querying btw is a 'memo' field with undefined length, not a
> normal textfield (which may be limited to 255 chars by definition?). could
> this have something to do with it?
>

That could have a lot to do with it. Please post the table definition
(ddl) and I'll see what I can do. Unfortunately I don't have access to a
6.5 version of SQL Server, so I'll have to try it out under 7.0. BTW you
might try 'select convert(text, mymemofield) from mytable' and see if
that's any different.

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