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
