Hello,
we have quite a lot of work with xml data which sometimes needs to be manualy imported into database and have run into this problem many times, soo now I desided to finally discribe it in hope that you will resolve this issue.
If i copy paste the xml content (using Large Data Editor) in a clob collumn in a table, the characters change because plsql developer changes them (i tried using Aqua Data and other programs and they work fine). If I imported the xml data using loader or reading it directly from the filesistem using oracle this would also work. I think the problem is with Large Data Editor.
If I used a blob collumn and then transform it into clob, the characters don't change.
Here is a more detailed step:
1. I have an xml:
SL
Živo govedo doma
we have quite a lot of work with xml data which sometimes needs to be manualy imported into database and have run into this problem many times, soo now I desided to finally discribe it in hope that you will resolve this issue.
If i copy paste the xml content (using Large Data Editor) in a clob collumn in a table, the characters change because plsql developer changes them (i tried using Aqua Data and other programs and they work fine). If I imported the xml data using loader or reading it directly from the filesistem using oracle this would also work. I think the problem is with Large Data Editor.
If I used a blob collumn and then transform it into clob, the characters don't change.
Here is a more detailed step:
1. I have an xml:
SL
Živo govedo doma
