Hi Luca,
I can understand that you are able to connect your SQL database to MATLAB using Database Explorer App but while trying to get data from your SQL database, the records having datatype of ‘varchar’ are not getting read in their actual form but are being read as empty strings {0x0 char}.
Please know that in this scenario, there are two languages interacting and interfacing each other and it is likely that a datatype compatible with the source language is not compatible with the target language. Conversion of datatype from source to the target language may not be performed implicitly when fetched from a different programming language and there might be a need to explicitly specify the datatype in which the data is to be imported in the target language which is MATLAB in this case.
Please refer the following MathWorks documentation link that provides with “Data Type support” of various databases with MATLAB:
Besides, “fetch” command can be used after connection is established. It also provides various “SQLImportOptions”.
You can refer this documentation for more information on “fetch” command:
I hope this helps!
