Page History

...

1. Have a varchar(4k) for data less than that

2. 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	Code Block ALTER TABLE grouper_config ADD config_value_clob clob; ALTER TABLE grouper_config ADD config_value_clob_bytes integer;
   Postgres	Code Block ALTER TABLE grouper_config ADD COLUMN config_value_clob varchar(10000000); ALTER TABLE grouper_config ADD COLUMN config_value_clob_bytes BIGINT;
   Mysql	Code Block ALTER TABLE grouper_config ADD COLUMN config_value_clob mediumtext; ALTER TABLE grouper_config ADD COLUMN config_value_clob_bytes BIGINT;
   Hsql	Code Block ALTER TABLE grouper_config ADD COLUMN config_value_clob clob; ALTER TABLE grouper_config ADD COLUMN config_value_clob_bytes BIGINT;

   
   

   
   

   
   
   

3. Have a column with size of larger data column (which also indicates that the larger column is being used)
4. Note we can base64 encode binary data in here if needed

...