Database Import escaping characters

[a9oble]

I am importing a CLOB column containing XML from an Oracle 11 database. All < > and " characters within the CLOB are coming in as escaped.
E.g.
<ReqStatus tc="1">PENDING</ReqStatus>
in the database column is coming into the editor as:
<ReqStatus tc="1">PENDING</ReqStatus>

Anyone know how I can change this behaviour to keep the original characters?

Thanks,

Adrian.

[Radu]

Dear Adrian,

All data in a table cell is considered to be text data and thus characters which are considered illegal in an XML element are escaped.
I will add an improvement request and see if we can at least add the option for users to specify that they want the data in a certain column to be literally added to the imported XML, without any escaping.

What you can do for now is that after the XML import file is produced to select all its content in the Text page, right click, choose Source->Unescape selection and unescape back all entities.

Regards,
Radu

[a9oble]

Radu,

Thanks for the explanation. I think that would be a good improvement, at least for me. Unfortunately, someone thought it a good idea to store their XML in CLOBS. Not really the best idea for highly structured data.

Thanks,

Adrian.

[Radu]

Hi,

In Oxygen 13 which will be available in a couple of days there will be a checkbox in the Oxygen preferences to disable escaping of XML content.

Regards,
Radu

[a9oble]

Radu,

That is great. I just got 13 downloaded and will try it out ASAP.

Thanks,

Adrian.