Matlab interprets SQL Server bigint as string

10 visualizzazioni (ultimi 30 giorni)
Andreas
Andreas il 20 Mar 2014
Commentato: Andreas il 20 Mar 2014
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 Commenti
Friedrich
Friedrich il 20 Mar 2014
Which driver do you use? What is your SQL query?
Andreas
Andreas il 20 Mar 2014
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.

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Structures in Help Center e File Exchange

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by