How to extend information field maximum size beyond 4000
605703Mar 26 2008 — edited Jun 10 2010We have a content metadata which needs to be able to support far more than 4000 characters, about 30000 to be more specific.
Memos are of VARCHAR2 type, which has a limit of 4000, and we've been able to use that size by setting the configuration variable MemoFieldSize to 4000 instead of the default size of 255.
The question is - Is it possible to set MemoFieldSize to 30000 and change the appropriate column in the DOCMETA database table to a CLOB type column in any way?
We tried the following procedure: First we set the MemoFieldSize variable to 30000, then changed an existing metadata column type to CLOB in the database directly, did a whole series of restarts, but we got an error when trying to checkin something with over 255 characters in that field. If we try to create a whole new field of the type Memo with MemoFieldSize=30000 the applet simply outputs an error saying that the size of the field we're trying to create is too large.
Thanks in advance for any suggestions,
- Tiago Dias