I am not able to extract big int from MS sql database using the oledb driver from matlab
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
denzil fernandes
le 19 Oct 2016
Commenté : denzil fernandes
le 3 Nov 2016
I am not able to extract big int datatype from MS sql database using the oledb driver from matlab. The return type of big int datatype of ms sql is returned as string and not as an integer after the execution of the query.
I do not want to type cast the returned value or use the str2num func .
Request anyone to please help in this regard.
0 commentaires
Réponse acceptée
Ankita Nargundkar
le 21 Oct 2016
To get the BIGINT data as INT64 into MATLAB you can retrieve the number as string and then use the attached MEX-file below to convert to INT64.
To retrieve the data as text you could consider changing the actual data format in your database or you could simply include a CAST in your query:
>> setdbprefs('DataReturnFormat','cellarray');
>> conn = database('myDatabase','myUser','myPassword');
>> res = exec(conn,'SELECT CAST(col1 AS VARCHAR) FROM myTable');
>> res = fetch(res);
>> data = res.data;
>> longlong = atoi64(data(:,1))
longlong =
12345678901234567
98765432104567895
Compile it using:
>> mex atoi64.c
Before using it.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!