Skip to Content.
Sympa Menu

freetds - Re: [freetds] Can't call databasepropertyex() on MSSQL over tds version 8.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Can't call databasepropertyex() on MSSQL over tds version 8.0
  • Date: Thu, 8 Apr 2010 10:24:39 +0200

Fixed hangs on CVS, fixed also variant support for tsql.

freddy77

2010/4/7 Frediano Ziglio <freddy77 AT gmail.com>:
> It seems that mssql 2005 returns a variant and our FreeTDS doesn't
> like that much... while 0.82 replace with NULL or empty I tested CVS
> HEAD and it hangs.
>
> freddy77
>
> 2010/4/7 Rafael Kitover <rkitover AT cpan.org>:
>> I just realized if I use:
>>
>> SELECT CAST(databasepropertyex(DB_NAME(), 'Collation') AS VARCHAR)
>>
>> then the query works on tds version 8.0 as well.
>>
>> That's all I needed.
>>
>>> On Mon, Apr 05, 2010 at 12:36:30AM -0400, Rafael Kitover wrote:
>>> > If I change it to:
>>> >
>>> > [global]
>>> >         tds version = 8.0
>>> >
>>> > Then the query no longer works:
>>> >
>>> > echo "select databasepropertyex(DB_NAME(), 'Collation')\ngo" | tsql -H
>>> > server -p 5000 -U sa -P pass
>>> > locale is
>>> > "LC_CTYPE=en_US.utf8;LC_NUMERIC=en_US.UTF-8;LC_TIME=en_US.UTF-8;LC_COLLATE=en_US.UTF-8;LC_MONETARY=en_US.UTF-8;LC_MESSAGES=en_US.UTF-8;LC_PAPER=en_US.UTF-8;LC_NAME=en_US.UTF-8;LC_ADDRESS=en_US.UTF-8;LC_TELEPHONE=en_US.UTF-8;LC_MEASUREMENT=en_US.UTF-8;LC_IDENTIFICATION=en_US.UTF-8"
>>> > locale charset is "UTF-8"
>>> > 1> 2>
>>> > NULL
>>> > (1 row affected)
>>> > 1> %
>> _______________________________________________
>> 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