MS SQL select SERVERPROPERTY

[MSchmidt]

TD 6.2 SP2 Connection to SQL Server XX via ODBC!


select SERVERPROPERTY('ProductVersion');

in TD 1.5.1 I get readable chars: 10.50.2500.0

In TD 6.1 SP2 I get "Asian" chars: 〱㔮⸰㔲〰.

You can test it with SQL Talk.
Connect to a SQL Server and run the SQL statement (see above).

Same behavior in TD. The INTO variable is not readable.

This happens only with an ODBC Connection.
With an OLE DB connection the product version string is readable.

regards
M.Schmidt

[MSchmidt]

Workaround:

select CONVERT(varchar(128), ( SERVERPROPERTY('ProductVersion')));

but I think in TD >5 such a function should deliver readable chars without a convert like in the workaround.

regards
M.Schmidt