Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Store string exceed 4,000 character in one column of a table

AliceFan-OracleFeb 9 2016 — edited Feb 9 2016

Hello there,

I have a form with multiple text area (using Rich Text Editor) associate with One data table.

Currently, I am using VARCHAR2(4000) for these text area.

I would like to know:

  1. If there is any data type I choose if I want to store data exceed 4,000 characters for each field(columns) and can store HTML data (Rich Text Editor UI)?
  2. I have noticed that APEX only support data types as follows:

Screen Shot 2016-02-09 at 10.57.37.png

3. Does APEX DB schema supports LONG type (not LONG RAW)

Screen Shot 2016-02-09 at 11.06.01.png

Thanks,

Alice
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2016
Added on Feb 9 2016
#apex, #apex-discussions
3 comments
934 views