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]> |
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