Q: Which Oracle long text data type can Bugzero use?
A: Oracle has two long text data types, LONG and CLOB.
Bugzero uses Oracle LONG so that it can use the standard java.sql API to
retrieve and insert text data. But keep in mind that LONG is deprecated and
its content can not be searched. To solve this problem, Bugzero split the
long text data into two places. One uses varchar2(4000) that can be searched;
and the rest uses LONG that will however not be searched.
CLOB can be searched but it uses the Oracle specific API to handle the data.
It is not portable and Bugzero does not use it.
* Reference brought to you by
Bugzero, it's more than just bug tracking software!