Matlab interprets SQL Server bigint as string

10 ビュー (過去 30 日間)
Andreas
Andreas 2014 年 3 月 20 日
コメント済み: Andreas 2014 年 3 月 20 日
I have some queries against a SQL Server 2012 64bit instance, on the table the columns are defined as:
- float - bit - decimal - bigint - bigint
the float and bit are recogized by Matlab as numbers, however the decimal and the bigint columns are strings, which again causes a very inefficient conversion.
Anybody having a hint or idea where the problem could be ?
I'm using MATLAB Version 7.13.0.564 (R2011b)
  2 件のコメント
Friedrich
Friedrich 2014 年 3 月 20 日
Which driver do you use? What is your SQL query?
Andreas
Andreas 2014 年 3 月 20 日
I didn't write the database interface myself, but from what I can see sqloledb is used as a provider, and then an ADODB.connection is created and a ComObj.Execute(query) is performed. The query is a SELECT * FROM a table valued function. The function returns the correct data types when I check within SSMS.

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeStructures についてさらに検索

製品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by