Matlab interprets SQL Server bigint as string

10 visualizaciones (últimos 30 días)
Andreas
Andreas el 20 de Mzo. de 2014
Comentada: Andreas el 20 de Mzo. de 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 comentarios
Friedrich
Friedrich el 20 de Mzo. de 2014
Which driver do you use? What is your SQL query?
Andreas
Andreas el 20 de Mzo. de 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.

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Structures en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by