Column names exceed maximum

cellprofiler

#1

Hi,
I constructed a quite complicated pipeline. This makes me run into the problem that the columns of the Per_Image table (export to Database) are truncated and therefore are no longer unique. I shortened the declarations of my objects, but is there a way to circumvent the problem?

Dani


#2

Hi Dani,

Both MATLAB and MySQL has a hard limit on variable/column name length (only 63 characters). Since we want to make sure the measurements are as descriptive as possible (as they can be quite complex), there currently isn’t any workaround other than shortening the object names as you’ve already done.

Regards,
-Mark