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.

Don't think of 'XML' as a data type!
XML is a means of describing data and so actually defines all of the data types
that it uses. Personally I view it as a means of transferring data between
databases rather than a means of storing data.

What you need to look at is what data you are handling. I have a system that
handles genealogical data which while there have been many attempts to move the
information to XML it's still more normally used in a less convoluted format. (
Simple does not bother putting the <>'s in. ) How this is stored in Firebird is
that there is a 'raw' record table which stores each record of the data in a
blob. That basically is the top level <record></record> and contains a random
amount of xml type data within it. The records are then extracted so that the
<name></name> fields form a new NAME table, with a link back to the raw record.
The same with other tags of the record such as <family> <source> <date> and so on.

XML does not map simply to SQL record types.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php