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





Archive powered by MHonArc 2.6.24.

Top of Page