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
==================================