SQL Developer

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!

What type to use for text comments of unknown length?

Ricardo LavezziSep 7 2017 — edited Sep 8 2017

I want to store comments on a table. I don't know how long those comments will be, but if I use the varchar type, I need to specify a length.

Searching on Internet, I found advice to use the text type, which apparently allows for unlimited (or non specified) text sizes.

But SQL developer does not offer that data type. Should I use BLOB?

I'm forced to use APEX to make an user interface (frontend?), so the data type should be compatible with APEX.

I welcome any advice on it.

This post has been answered by Hendrik Schmidt on Sep 7 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2017

Added on Sep 7 2017

#sql-developer

9 comments

420 views