Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Rich Text Edit Data Field Type

  1. How-to
0
Votes
Undo
  1. Kevin Thai
    Kevin Thai
  2. PowerBuilder
  3. Monday, 10 April 2023 20:22 PM UTC

Hi all,

 

We are experimenting on using rich text edits in our program, when we had a question about which data type can rich text edit uses. I tried to search up some articles but did not find a definitive answer and was hoping someone on here as the answer. We are not sure if we should use a TEXT field or VARCHAR(MAX) field to contain our rich text field. We are using a Microsoft SQL Server. 

 

Thanks!

  1. PowerBuilder
  2. Rich Text
IIS server PowerBuilder + .net runtime file instal...
Dropbox files from PB
Accepted Answer
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 10 April 2023 20:59 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi, Kevin -

Use a database data type that can hold a variable amount of character data. There is no recommended size, because the size requirement depends on the amount of text a user will enter. Keep in mind that information in RTF format contains extra "behind-the-scenes stuff" in order to be able to describe and reproduce the text formatting in addition to the actual text content.

See the following recent Q&A post to get an idea of what I'm referring to:

    https://community.appeon.com/index.php/qna/q-a/dw-richtext-edit-stye-doesn-t-display-prior-data

Best regards, John

Comment
There are no comments made yet.
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 11 April 2023 15:00 PM UTC
  2. PowerBuilder
  3. # 1

ntext, text, and image (Transact-SQL) - SQL Server | Microsoft Learn

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.