FreeTDS and text data type

[Sebastian Enders]

Hello,

i have got a problem with FreeTDS.
Everything works fine with TDSVER=42 and TDSVER=70.
But with TDSVER=42 you have a varchar data type limit of 255 character.
With TDSVER=70 it works fine and you have not a character limit. But you
can not access a text field.
There must be an bug in the freetds TDSVER=70.
As anybody an idea how to patch it, or has anybody a patch for this bug??

Please help me!!!!!
:-)

Thanks a lot,

Best regards,
Sebastian Enders
enders at comvos.de

[Sebastian Enders]

Hi,

Nobody has an idea how to patch the freetds to work fine with text data
types in TDS version 7.0????

Bye,
Sebastian

Post by Sebastian Enders
Hello,
i have got a problem with FreeTDS.
Everything works fine with TDSVER=42 and TDSVER=70.
But with TDSVER=42 you have a varchar data type limit of 255 character.
With TDSVER=70 it works fine and you have not a character limit. But you
can not access a text field.
There must be an bug in the freetds TDSVER=70.
As anybody an idea how to patch it, or has anybody a patch for this bug??
Please help me!!!!!
:-)
Thanks a lot,
Best regards,
Sebastian Enders
enders at comvos.de

[Bob Kline]

Post by Sebastian Enders
Nobody has an idea how to patch the freetds to work fine with text
data types in TDS version 7.0????

1. Have you looked through the mailing list archives?
2. Have you pulled down the latest version of the code?

[Sebastian Enders]

Post by Bob Kline

Post by Sebastian Enders
Nobody has an idea how to patch the freetds to work fine with text
data types in TDS version 7.0????

1. Have you looked through the mailing list archives?

Yes of course, nobody discussed this problem.

Post by Bob Kline
2. Have you pulled down the latest version of the code?

Yes i did, it doesn?t work either. :-(

Everything works fine, but text data types doesn?t work.
I saw that few people have had the same problem, and they couldn?t fix it
or managed it either.

Perhaps you have an idea?

Would be very nice!

Best regards,
Sebastian

[Vincent Apesa]

X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <OE39Yg83alUohIi6YEF00001486 at hotmail.com>
X-OriginalArrivalTime: 02 Oct 2000 13:47:42.0897 (UTC) FILETIME=[566B3210:01C02C77]

I'm not sure if this is even related but ....

with SQL Server 7 and ASP in order to select a text data type I have to run
the "set text size <number of bytes>" before executing the query to the SQL
Server I want more than just the first 256K.
I usually just write a stored procedure to grab that rows I want.
..
set text size 16384
select id, bigTextThing from X ...
...


Vince
----- Original Message -----
From: "Sebastian Enders" <enders at comvos.de>
To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
Sent: Monday, October 02, 2000 9:38 AM
Subject: [freetds] Re: FreeTDS and text data type

Post by Sebastian Enders

Post by Bob Kline

Post by Sebastian Enders
Nobody has an idea how to patch the freetds to work fine with text
data types in TDS version 7.0????

1. Have you looked through the mailing list archives?

Yes of course, nobody discussed this problem.

Post by Bob Kline
2. Have you pulled down the latest version of the code?

Yes i did, it doesn?t work either. :-(
Everything works fine, but text data types doesn?t work.
I saw that few people have had the same problem, and they couldn?t fix it
or managed it either.
Perhaps you have an idea?
Would be very nice!
Best regards,
Sebastian
---
You are currently subscribed to freetds as: [vapesa at hotmail.com]
To unsubscribe, forward this message to

$subst('Email.Unsub')

[Michael Kimsal]

I missed a few messages (and probably can't help anyway!)
but what's the problem? We're using text types with little problem.
The problems I have seem to be more related to the size of the query
string in general rather than data type, as far as I can see.
Short answer - the longer the query string, the more likely it
is the process will hang. Not scientific I know, but it's all I can
see so far.

Mind you, our 'text' fields are still generally under 10k - I haven't tried them
holding >10k, so that may be where the problem is.

Can you get text fields to work at all?

Post by Vincent Apesa
----- Original Message -----
From: "Sebastian Enders" <enders at comvos.de>
To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
Sent: Monday, October 02, 2000 9:38 AM
Subject: [freetds] Re: FreeTDS and text data type

Post by Sebastian Enders

Post by Bob Kline

Post by Sebastian Enders
Nobody has an idea how to patch the freetds to work fine with text
data types in TDS version 7.0????

1. Have you looked through the mailing list archives?

Yes of course, nobody discussed this problem.

Post by Bob Kline
2. Have you pulled down the latest version of the code?

Yes i did, it doesn?t work either. :-(
Everything works fine, but text data types doesn?t work.
I saw that few people have had the same problem, and they couldn?t fix it
or managed it either.
Perhaps you have an idea?
Would be very nice!
Best regards,
Sebastian
---
You are currently subscribed to freetds as: [vapesa at hotmail.com]
To unsubscribe, forward this message to

$subst('Email.Unsub')
---
You are currently subscribed to freetds as: [michael at tapinternet.com]
To unsubscribe, forward this message to $subst('Email.Unsub')

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961

[Bob Kline]

Post by Sebastian Enders

Post by Bob Kline

Post by Sebastian Enders
Nobody has an idea how to patch the freetds to work fine with text
data types in TDS version 7.0????

1. Have you looked through the mailing list archives?

Yes of course, nobody discussed this problem.

Really? How about this response from Brian B. on 15 Aug?

Post by Sebastian Enders
you have to 'set textsize 8192' or whatever number you are looking
for, prior to issuing the query.

Have you tried this?