How much total memory is there on each BCM Record's "Notes" fields?

  • Thread starter Thread starter Tim P via OfficeKB.com
  • Start date Start date
T

Tim P via OfficeKB.com

Can anyone tell me if there is a limit to how much text can be entered into
the "Notes" fields that are located behind the Details tab of each Account,
Business Contact, Opportunity Record item? Additionally, I would ask this
same question of how much text can you enter into each Outlook Task record's
comments field? I realize that the native Outlook Task item is not part of
the BCM db but rather is stored to the Outlook pst.

Thanks for any info.

-THP
 
The file db_neutral_script.sql is used by BCM to build the database. It
has the details about all the fields in the database.

Fields ContactNotesTable.ContactNotes and
ActivityNotesTable.ActivityNote are both of type nvarchar and size
4000. I suspect that how much text you can get in there will depend on
the encoding. So the answer is either 2000 or 4000 characters. You can
do an experiment and fill notepad with 4K worth of text (or maybe a
little less) and see if you can paste it all into a notes fields, save
it, and get it all back.

No idea about Outlook Task Notes field, but it's probably very large.
 
Thanks Luther,

I interpret from your reply that the Notes/Comments field on each Task item
in the Outlook pst would likely have far greater storage capaciity for large
amounts of text as compared to the Notes fields within the various record
objects contained within the BCM db. I will do some experimenting.
Meanwhile, if any one else has more information about this please post.

Thanks,

-THP
 
Back
Top