freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.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 11:47:35 +0100

>
> 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] Empty string in varcharmax column in ODBC mode, Sokol, Ryan - 244, 01/03/2007
- <Possible follow-up(s)>
- Re: [freetds] Empty string in varcharmax column in ODBC mode, ZIGLIO, Frediano, VF-IT, 01/04/2007
  - Re: [freetds] Empty string in varcharmax column in ODBC mode, Sokol, Ryan - 244, 01/04/2007