Skip to main content
chrisg0006
chrisg0006
July 17, 2023
Solved

Field Format for a Rich Text Field

  • July 17, 2023
  • 6 replies
  • 0 views

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?

Best answer by mikes0011

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.

6 replies

mikes0011
mikes0011
Brainy
July 17, 2023

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?

The Expression Guru
chrisg0006
chrisg0006Author
July 17, 2023

I'm using the Avanced Rich Text Editor from Vuram.  I need to have a large description field where the user can enter text, images or create tables.  I need to know that would the field format be in the database?

mikes0011
mikes0011Answer
Brainy
July 17, 2023

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.

The Expression Guru
    Terms & ConditionsAccessibility statement