title: oracle sql - to store 4000 characters in a column of my DB table
body: <p>In my web application, I am saving some Text message in a COLUMN of a DB table(Oracle). Earlier the VARCHAR2 length(maximum length) is (500 BYTE). Now the client has asked me to increase the maximum length to 4000 characters.<br>
  Is it possible to save 4000 char in a column of a DB table or do we need to save it as BLOB.<br>
  Which gives better performance?<br>
  Can anyone please clarify on this?</p>