Mahesh Pratihari wrote: > Could you please let me know the best fit data type in XML in firebird, > as firebird doesn't support the xml data type? > > I need the alternative data type of it.
If you later need to query this data, then you should really store it in tables instead of a single blob column. A useful tool to help you determine the structure is XMLWizard. It will suggest the table(s), columns and datatypes you should use: http://www.guacosoft.com/xmlwizard HTH -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==================================