storing xml

[joshua k]

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).]

[Frank Carver]

"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.

[Muhammad Ali]

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.

[Ajith Kallambella]

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.

------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.

[Frank Carver]

This is really more of a database question than one on XML, so I've moved it over. You may want to search the database forum to see if a solution has already been posted, too.