9 Replies Latest reply on Sep 8, 2017 6:01 PM by rp0428

    What type to use for text comments of unknown length?

    Ricardo Lavezzi

      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.