Re: Can't call databasepropertyex() on MSSQL over tds version 8.0
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Fixed hangs on CVS, fixed also variant support for tsql. freddy77 2010/4/7 Frediano Ziglio <[email protected]>: > 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 <[email protected]>: >> 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 >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds