datajoint-matlab icon indicating copy to clipboard operation
datajoint-matlab copied to clipboard

Added Mysql text datatype support as a string

Open Alvalunasan opened this issue 3 years ago • 2 comments

A quick fix just to add text datatype as support

When this is not added I get the following error:

bdatatest_schema = dj.Schema(dj.conn, 'bdatatest', 'bdatatest')
Error using dj.internal.Declare.matchType (line 430)
UnsupportedType: Attribute type 'text' is not a valid type.

Alvalunasan avatar Feb 08 '22 02:02 Alvalunasan

Thanks, @Alvalunasan. What is the reason for adding the text datatype? Are there cases where varchar or longblob are insufficient? We need to be careful with adding support for new types because their distinct usecases must be well explained and documented and support added across both languages: MATLAB and Python.

dimitri-yatsenko avatar Feb 08 '22 11:02 dimitri-yatsenko

Hi @dimitri-yatsenko thanks for the response. Basically, we need to fetch with DJ an already existing DB that was created with text (and mediumtext) fields.

Alvalunasan avatar Feb 08 '22 12:02 Alvalunasan