VARCHAR2 « Oracle « JPA Q&A

1. Oracle's 4000 character VARCHAR2 limit

We use Oracle as our database. It has a limit of 4000 characters for its VARCHAR2 datatype. So, when I wanted to persist some *long* String data, I had to come up with something more than just one VARCHAR2 column. I originally looked at using a CLOB, but after investigating the effort required to deal with Oracle CLOBs, I decided to ...

2. Hibernate 2.1.7, Oracle and long/varchar2