[freetds] Empty string in varcharmax column in ODBC mode
Sokol, Ryan - 244
ryans at HA.com
Thu Jan 4 08:16:22 EST 2007
I'm using FreeTDS 0.64
I'm using the 7.0 protocol. Note: I've tried many times to use the 8.0
protocol, but it causes character problems.
No core dump or error, just a hang.
Description is a varchar(MAX) field that is nullable.
Sorry, not varcharmax. I meant varchar(MAX).
-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of ZIGLIO,
Frediano, VF-IT
Sent: Thursday, January 04, 2007 4:48 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Empty string in varcharmax column in ODBC mode
>
> I think I have stumbled upon a bug in the ODBC implementation of
> FreeTDS.
>
>
Which version are you using?
Which protocol version are you using?
>
> If you run the following query in ODBC mode against a SQL SERVER 2005,
> the query fails to finish.
>
>
Core dump, hang or error?
>
> Select ISNULL(D.Description,'') AS Description from some_table
>
Description is a varchar field? Is it nullable?
>
>
> If the column D.Description is a varcharmax, the query does
> not finish.
What's varcharmax?
> Here's the kicker, it only fails about 50% of the time.
>
>
>
> Note: this works fine in db-lib mode.
>
>
>
> Thanks.
>
bye
freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list