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: Fri, 17 Nov 2000 10:39:12 +0100


hm. i configured snapshot freetds, compiled and installed it, reconfigured
php, compiled, installed it and finaly same for apache. i though freetds
re-install would be enough but that didnt seem to work. it makes a logfile
but that has no 'dbdatlen's in it. but after the complete recompile it still
didnt work. i did a grep of 'dbdatlen' in the /usr/local/freetds/lib dir and
got 4 hits so i assume it's compiled in there ok. but doing my query on the
database, the freetds.log file doesnt contain 'dbdatlen' entries. here's a
portion of that file:
Sending packet @ 2000-11-16 15:41:08
0000 01 01 00 56 00 00 00 00 53 65 6c 65 63 74 20 50 |...V....Select P|
0010 72 6f 6a 5f 61 6e 74 77 6f 6f 72 64 20 0d 0a 20 |roj_antwoord .. |
0020 20 20 20 46 52 4f 4d 20 64 62 6f 2e 53 55 50 50 | FROM dbo.SUPP|
0030 4f 52 54 50 52 4f 4a 45 43 54 20 0d 0a 20 20 20 |ORTPROJECT .. |
0040 20 57 48 45 52 45 20 28 50 72 6f 6a 5f 6e 72 3d | WHERE (Proj_nr=|
0050 36 32 32 36 36 29 |62266)|


2000-11-16 15:41:08 inside ct_results()
2000-11-16 15:41:08 processing result tokens. marker is a0
2000-11-16 15:41:08 processing result tokens. marker is a1
2000-11-16 15:41:08 inside tds_process_default_tokens() marker is a1
2000-11-16 15:41:08 processing result tokens. marker is d1
2000-11-16 15:41:08 inside ct_res_info()
2000-11-16 15:41:08 inside ct_describe()
2000-11-16 15:41:08 inside _ct_get_client_type()
2000-11-16 15:41:08 inside ct_describe() datafmt->datatype = 16 server type
35
2000-11-16 15:41:08 inside ct_bind()
2000-11-16 15:41:08 inside ct_bind() item = 1 datafmt->datatype = 1
2000-11-16 15:41:08 inside ct_fetch()
2000-11-16 15:41:08 processing row tokens. marker is d1
2000-11-16 15:41:08 setting column 0 to NULL
2000-11-16 15:41:08 inside _ct_bind_data()
2000-11-16 15:41:08 inside _ct_get_server_type()
2000-11-16 15:41:08 inside _ct_bind_data() converting column 0 from type 35
to type 47
2000-11-16 15:41:08 inside _ct_bind_data() setting source length for 0 =
2154
2000-11-16 15:41:08 inside _ct_bind_data() conversion done len = 255 bindfmt
= 1
2000-11-16 15:41:08 inside _ct_bind_data() length binding len = 255
2000-11-16 15:41:08 inside ct_fetch()
2000-11-16 15:41:08 processing row tokens. marker is fd
2000-11-16 15:41:08 inside ct_results()
2000-11-16 15:41:08 inside ct_results()
2000-11-16 15:41:08 inside ct_con_props() action = 25 property = 26
2000-11-16 15:41:08 inside ct_close()
2000-11-16 15:41:08 inside ct_con_drop()

i hope this helps, else tell me how to

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


You can grab the latest snapshot off of the download page and that should
work just fine.

Brian

On Wed, 15 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> excuse me for asking but how do i get into cvs... i cant seem to connect
>
> -----Original Message-----
> From: Brian Bruns [mailto:camber AT ais.org]
> Sent: woensdag 15 november 2000 0:27
> To: TDS Development Group
> Subject: [freetds] Re: 255 char limit in result queries
>
>
> The extra debugging stuff is checked in to cvs, please grab that and run
> after setting the TDSDUMP environment variable. As in,
>
> export TDSDUMP=/tmp/freetds.log
>
> Look for messages that have 'dbdatlen' and post those. (It is helpful to
> compile the CGI version of PHP so you can run it from the command line.
>
> Brian
>
> On Tue, 14 Nov 2000, Brian Bruns wrote:
>
> > 16 refers to the size of the text pointer that is stored with the row
(the
> > actual data in a text field is stored on its own page). Anyway, now we
> > know that it is not being cast as a smaller value (such as char). I
have
> > some ideas on where things may be going wrong...I'll put up a special
copy
> > of freetds tonight with some extra debugging stuff in it that should
help
> > us out.
> >
> > Brian
> >
> > On Tue, 14 Nov 2000, Brug, Herco van -Syntegra NL wrote:
> >
> > > well my access tells me the proj_toel and proj_antwoord fields are or
> type
> > > memo and as far as i can figure they're 16 textfields long. point is
> that
> > > when i query them i only get the first 255 bytes from them. now
> 16x255byte
> > > is about 4KB which may well be the limit of those memofields but i
think
> > > freetds somewhere believes they are indeed textfields and returns only
> 255
> > > byte.
> > > i do think that we're getting closer to the problem
> > >
> >
> >


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