Skip to main content
chrisg0006
Inspiring
Jul 17, 2023 6:42 PM UTC
Solved

Field Format for a Rich Text Field

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?

mikes0011
mikes0011Answer
Brainy
Jul 17, 2023 7:09 PM UTC

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

6 replies

mikes0011
Brainy
Jul 17, 2023 7:02 PM UTC

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
Inspiring
Jul 17, 2023 7:05 PM UTC

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
Jul 17, 2023 7:09 PM UTC

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