Problems with exporting multiple datatypes from database toolbox

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?

[MSTK]

The issues number 3 and 4 were resolved by switching to the JDBC driver.

[MSTK]

As was issue 1 and 2. The documentation should contain a recommendation to use the JDBC driver.