XML Dump text becomes hex?

[jeff benjamin]

On Tuesday, May 27, 2003, at 04:08 PM, Ruslan Zasukhin wrote:

>> I open a vdb with VAPP and do an XML Dump. The field defined as TEXT
>> named 'caption' has its data displayed in hex instead of ascii (see
>> example below). Is this normal and is there a way to change the
>> behavior?
>
> Yes this is normal for now.
>
> I have decide go by this way, because otherwise I do not see how to 
> make
> nice looking readable XML text.
>
> Just think that TEXT field contains MULTI-line text, with new lines.
> So we can get very garbage on look XML file.

What happens if a varchar contains MULTI-line text? Or a char?

I think it would be nice to have an option of how the text is presented 
in the XML.

Just my $.02

Regards,
Jeff