In Grouper 2.5.0 patches we will support large text widths in the database.
Different databases handle this differently. And it is less efficient than a varchar(4k). So
- Have a varchar(4k) for data less than that
Have a column for larger data
Database Large text column type Max storage DDLUtils Hibernate Notes Oracle clob 4gig yes yes though might need a different mapping file Postgres varchar 10meg no yes with String if we need more space, text goes up to a gig Mysql mediumtext 16meg no yes with String if we need more space, longtext up to 4 gig Hsql clob 16meg yes yes though might need oracle mapping file Database DDL Oracle Postgres Mysql Hsql
- Have a column with size of larger data column (which also indicates that the larger column is being used)
- Note we can base64 encode binary data in here if needed
Use this for config in database, attributes, etc