Skip to Content.
Sympa Menu

freetds - Re: [freetds] Empty string in varcharmax column in ODBC mode

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Sokol, Ryan - 244" <ryans AT HA.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Empty string in varcharmax column in ODBC mode
  • Date: Thu, 4 Jan 2007 07:16:22 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page