Can't call databasepropertyex() on MSSQL over tds version 8.0
Rafael Kitover <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi guys,
Suppose in my /etc/freetds/freetds.conf I have:
[global]
tds version = 7.0
Then this 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>
SQL_Latin1_General_CP1_CI_AS
(1 row affected)
1> %
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> %