[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