I may have found a bug with IJC 5.9.3
I have a structure table in an Oracle database with a JChem index, the structure column is VARCHAR2 (2000) as I prefex to store the structures as Smiles
The table has been promoted into IJC, and in the Entity extra attributes for the Column I have chosen the Format to Save Structure to be Smiles.
When I use the 'Add' row from the Form, this works fine and Smiles are inserted into the database.
However, when I import an SD file, the structures are saved as MolFiles, which means that I exceed the 2000 limit for my column.
Can you let me know if you can reproduce the issue, is there another option which could be used as a work-around ?
At the moment, we will have to convert the structures to Smiles and then import a Text file.