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, 15 Nov 2000 16:29:22 +0100


yes it is support to work. on an nt box running php using an odbc connection
to the same database it runs fine. so the data is there and is delivered to
the query in good health. just when using freetds and mssql/sybase-ct
connectors it cuts the data off.

-----Original Message-----
From: James K. Lowden [mailto:jklowden AT speakeasy.org]
Sent: woensdag 15 november 2000 3:33
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries


Mrrph? Am I missing something? Is this *supposed* to work?

A dblib programmer has to use dbreadtext & Co. to read text fields. Is the
server
converting the text field to varchar(255) implicitly before the (I assume)
ODBC driver
ever sees it? Or is the ODBC driver expected to do some fancy footwork to
make text
fields act like normal data types?

My users, you see, had to keep it short. No silly-ass text fields for them,
no sir.
Nothing by God-fearing varchars. Keep it short or don't say it at all, that
was my
motto. Or else.

Ahem.

--jkl


> 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

(earlier...)

> this is part of the code i use
> $id=mssql_connect("Support", "username", "");
> $db=mssql_select_db("Support");
> $r1=mssql_query("Select dbo.SUPPORTPROJECT.Proj_toel,
> dbo.SUPPORTPROJECT.Proj_antwoord FROM dbo.SUPPORTPROJECT
> Where (Proj_nr=$pn)",$id);
>


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