FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

run 'sp_help <tablename>' and post the output.  That should be sufficient.
Make sure you give the query also.

Thanks,

Brian

On Tue, 7 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> 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
> -----------------------------
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>