add structure of different format to standard table as blob

User 55ffa2f197

02-07-2013 15:26:07

Hi, In my stanfard orcle table the structure column is defined as blob. Due to the nature of the structure source it may come in as smiles, reactions rxn, or MDL mol ctab. When i add a smiles to the structure column which format and jchem mathod  i should use to insert the smiles to the structure column. Should I convert smiles to graphmol then insert .... I have put the cartridge index on this blob column to make the structure searchable, and structureType for cartridge index building is anymolecules.


Thanks


Dong

ChemAxon aa7c50abf8

03-07-2013 12:45:38

Hi,


You can insert structures in any representation format.


Peter