GeoMultiPolygon limited to 255 characters in DetailView

Support
#1

Dear Jmix Team

I have an entity with a GeoMultiPolygon Field.

Liquibase generated a field with 8 KB. The entryfield is limited to 255 Characters.

After adding maxLength="1048576" I could enter the string but not store it ( as the field is to small ).

After changing now the field in the MariaDB from char to longtext, liquibase again tries to put it back, so i have to put it to the ignorelist.

Now I can cut and paste and store a string to this entry field. But I cannot scroll until the end of the field to position 93718, the display of text and the ability to edit is cut at 96402 … .

We have data ( limits of departments ) from 97 KB to 477 KB.

I did solve the problem and will teach the user how to come around this, but I think, this should be done better.

Regards

Felix

#3

Hello Felix,

Liquibase generated a field with 8 KB.

This is default length for MultiPolygonDatatype. For now changing length in the generated changelogs is the only way override the datatype length.
I’ve created an issue to make it more JPA way - using Column#columnDefinition attribute: https://youtrack.jmix.io/issue/JST-6132/Studio-ignores-ColumncolumnDefinition-attribute-for-custom-datatypes

The entryfield is limited to 255 Characters.

When a field is bound with entity property, it can retrieve some limitations from meta annotations. For instance, max length = 255 in the TextField is taken from Column#length attribute.
You can define the length attribute with required value or add @Lob annotation to ignore max length limitation.

1 Like