XML element question

[Patros]

Greetings,
Basically I am attempting to store oracle data in an xml format
e.g.
<ElementType name=&quot;genre &quot; content=&quot;textOnly&quot; dt:type=&quot;string&quot;/>
<ElementType name=”warning &quot; content=&quot;textOnly&quot; dt:type=&quot;string&quot;/>

Anyway my question is, how do I store the clobs and blobs? what is the type for these?
Thanks in advance,
Patros

 

[Nosferatu]

XML-aware programs should be capable to display only readable text data (that match the different encodings specified in the xml document declaration).
To store binary objects, you have to convert them to base64 data (or MIME format), which contains only readable characters.
Or, you could store the binary objects in separate files and reference them from XML. It all depends on what are you trying to achieve with the XML you're creating: data conversion, presentation, transmission etc.
[red]Nosferatu[/red]
We are what we eat...
There's no such thing as free meal...
once stated: methane@personal.ro