Matlab interprets SQL Server bigint as string

조회 수: 8 (최근 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 CenterFile Exchange에서 Structures에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by