Field Format for a Rich Text Field

Question

If I intend to use Rich Text for a field in an application, what type of formatting should the field have in the database? Would a Varchar(4,000) work for example?

Mike Schmitt · Accepted Answer

Not having used it very recently, my assumption is that it saves HTML-coded plaintext - in that case you should be fine using varchar in the DB, with a sufficient size to allow users to enter as much text (counting html tags) as you want.

Stefan Helzle · Answer

VARCHAR only supports up to 4000 characters, Synced records also limit to 4000 characters, You will have to use a non-synced record and one of the "TEXT" field types.

Mike Schmitt · Answer

Can you say anything more about your use case? Are you talking about the out-of-box Rich Text Display? Or the plug-in for Rich Text Entry? What are your requirements - how much data do you intend to allow users to enter / what would the typical and/or max lengths be?

Field Format for a Rich Text Field

Top Replies