how do i store an xml string in a database the " and ' chars do not allowing me to store the xml string i've tried vaarchar2,clob,long raw none work any suggestions will be welcome!!! ------------------ josh [This message has been edited by joshua k (edited February 01, 2001).]
"joshua k", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements. Thanks.
I am not an expert of the field. However, I faced the same situation and had to write an encoding function myself. It replaced all single or double quotation marks in a string with my own strings. I mean you need a custom designed solution made by yourself. There is no other way out. Just my opinion. Muhammad Ali Shah Karachi.
Here are some suggestions - a) Since ALL attribute values needs to be quoted, you can simply omit the quote while storing and put the quote while restoring. b) Use some kind of a unique pattern( eg - #*quote*# ) while storing and replace it with the actual quote while retreiving.