FreeTDS Development Group

[Rafael Kitover <rkitover AT cpan.org>]

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