Skip to Content.
Sympa Menu

freetds - [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: Rafael Kitover <rkitover AT cpan.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Can't call databasepropertyex() on MSSQL over tds version 8.0
  • Date: Mon, 5 Apr 2010 00:36:30 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page