Oracle-based bug and defect tracking software
Bugzero one-for-all bug tracking and help desk support system
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!

Home - FAQs