Not sure if this belongs here or in “Database” community, but, here goes.
Can an Apache Lucene Solr collection index a datatype CLOB in a database?
I ask because someone, here, wants to increase the capacity of what is currently a varchar2(4000) column, and they are considering converting it to CLOB. But there is a Solr collection that is indexing data in the current varchar2 column, and I would like to know if Solr collections can index CLOB?
It’s my understanding that CLOB can take string data and store it in large amounts (something like 8TB, I think), but CLOB will lose some string search/manipulation abilities if that is used.
Thoughts? Opinions? Comments?