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.