Redstone Content Solutions
  • About
  • Solutions
  • Product
  • Cloud
  • Business Blog
  • Technical Blog

Expanding Metadata Field Sizes

8/28/2008

1 Comment

 
There are at least two possibilities for increasing metadata field sizes. The request most often heard inquires about increasing the default memo field size (which is originally 255 characters). The second avenue is to increase the size for a single one-off metadata field.

Expanding Default Memo Field Size
We can use a configuration variable within Content Server named "MemoFieldSize" to increase the default size of new memo fields beyond the original limit of 255 characters. Keep in mind this affects memo fields that you create AFTER you add this configuration and restart content server. For fields that have already been created you will also need to go into the database and directly increase the column size for that individual metadata field within the DocMeata table.

If you operate in a database with UTF8 encoding you should keep in mind that this can affect that actual number of characters your users will be able to input. Oracle has a 4000 byte per column limit for varchar2/nvarchar2 data types. Hence, if you set the column to the 4,000 byte maximum and each character takes 3 bytes of space you get roughly 1,333 characters to work with.

So, what to do where, when and how. Log into your content server with administrative privileges and select Admin Server from the Administration menu. Click the button for the instance you will be working with and then select General Configuration from the left hand menu.  Add this configuration setting:

MemoFieldSize=1024

as a new line in the variables list and click save.  Restart.  Similarly you could go directly to the file system and add this configuration setting to the config.cfg file.  Oh, and don't forget to get out your favorite database manipulation device and increase those columns sizes!

Expanding a Single
FieldGreat, right, so that's all nice and what not but I don't want to increase ALL my memo fields. I only want to increase the size of a single field. Well sure you do, who wouldn't? In this case you can again use config.cfg or go through the admin server to add a configuration setting something like this:

xMyMetadatafield:maxLength=1024

or whatever your new field size is meant to be.  Again, change the table definition in the database and restart your content server.

Notes:

  1. Increasing field sizes also more than likely will increase indexing and searching time.  More stuff equals more time.  Pretty simple, but a reminder of that fact is relevant.
  2. I performed these actions on a 10gR3 content server and 11g database with existing content. The field widening did NOT erase my data. Obviously if I were to restrict down the field size instead of widen the field my data would have been truncated.
1 Comment
Melissa
11/19/2013 06:51:23 am

For increasing the size of metadata field there are two possibilities. One is to increase the default memo field size and other one is to increase the size for a single one-off metadata field. According to my opinion the first one is easy and convenient to use.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Build your career in software development at Redstone Content Solutions as an Oracle WebCenter Consultant

    Categories

    All
    Collaborate
    Content Server
    Database
    Dev Tricks
    Digital Asset Management
    Linux
    Misc
    Oracle OpenWorld
    Oracle OpenWorld
    Oracle UCM
    Oracle UCM
    WebCenter Content
    WebCenter Sites
    WebLogic Server

    Archives

    March 2017
    June 2015
    December 2014
    June 2013
    February 2013
    October 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    February 2012
    January 2012
    December 2011
    October 2011
    September 2011
    July 2011
    June 2011
    May 2011
    April 2011
    February 2011
    January 2011
    October 2010
    September 2010
    August 2010
    July 2010
    May 2010
    April 2010
    March 2010
    February 2010
    December 2009
    November 2009
    October 2009
    September 2009
    August 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    December 2008
    November 2008
    October 2008
    September 2008
    August 2008
    July 2008

Powered by Create your own unique website with customizable templates.
  • About
  • Solutions
  • Product
  • Cloud
  • Business Blog
  • Technical Blog
✕