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]