Hi Lester,
Thanks a lot for your Mail. I checked in SQL there is a data type 'XML' exist, so I can stored all the xml data there, similarly how I can achieve in Firebird Thanks Mahesh ________________________________ From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Lester Caine Sent: Friday, November 18, 2011 5:10 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] XML Data type 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// <http://medw.co.uk/> Firebird - http://www.firebirdsql.org/index.php [Non-text portions of this message have been removed]