How to extract data from a SQLite database with null values

I have a db file and I would like to extract certain data.

Code:

dbfile = 'name_database.db';
conn = sqlite(dbfile);
%Import all the data from productTable. The results output argument contains the imported data as a cell array.
 sqlquery = 'SELECT * FROM table_name';
 record_db = fetch(conn,sqlquery);

However, whe a particular table has 'NULL' values I get the following error:

Error using matlab.depfun.internal.database.SqlDbConnector/fetchRows

Unexpected NULL; (zero-based) column index: 1. Details: [initVecVarVecFromSqldbTypes].

Error in sqlite/fetch

NOTE: The databse has been created by a thirdparty, so I cannot modify how the database is created.

Thanks in advance

Answer 1

[Bhomik Kankaria]

Hi Paloma,

As of MATLAB R2020a, the handling of NULL values is a limitation of the MATLAB interface to SQLite (this limitation is described towards the bottom of this documentation page).

The only available workaround is to connect to the SQLite database using a JDBC driver (more information on this can also be found in the documentation page linked above).