MS SQL select SERVERPROPERTY

General discussion forum about all databases other than SqlBase.
MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

MS SQL select SERVERPROPERTY

Post by MSchmidt » 19 Dec 2012, 17:05

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
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

Re: MS SQL select SERVERPROPERTY

Post by MSchmidt » 19 Dec 2012, 17:35

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Applebot], [Ccbot] and 6 guests