Problems with exporting multiple datatypes from database toolbox
2 次查看(过去 30 天)
显示 更早的评论
Hi all,
I am trying to export a dataset with multiple datatypes (integers +floats) to a Postgres SQL database using the insert function, but am experiencing multiple issues.
1) When trying to use insert and a cell array as input, the function only allows one datatype (either integers or doubles). When mixing, get fault messages like "Invalid input value at row 1, column 14. Expected double."
2) When trying to using use a struct instead of a cell array, I get "Error using database.odbc.connection/insert (line 268) Input structure must contain fields of type double or cell"
3) When trying to export Boolean data, I get "Error using database.odbc.connection/insert (line 268) Driver unable to retrieve length for column number: 2"
4) When importing data and examining the metadata, numbers that are specified as double precision in the database are listed as VariableType 'single'.
Has anyone had experience with any of these issues?
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!