stomata
asked on
Double quote in SQL insert values..
Hi everybody, I am a new one. I am doing a porject on network database. Just got stuck on the problem of double quote.
I want to insert the sentence:
<b>it is as good as "Wonderfulland"</b>
I take this statement and try to insert to my db2 databse, but it turns out giving me a sentence of :
<b>it is as good as</b>
seems like it delete everything inside the double quote.....
but whne I try:
<b>it is as good as ""Wonderfulland""</b>
DB2 SQL can take the whole sentence.....
Just how can I enter the original sentence will only one pair of double quotes into DB2 database usinf SQL?
I want to insert the sentence:
<b>it is as good as "Wonderfulland"</b>
I take this statement and try to insert to my db2 databse, but it turns out giving me a sentence of :
<b>it is as good as</b>
seems like it delete everything inside the double quote.....
but whne I try:
<b>it is as good as ""Wonderfulland""</b>
DB2 SQL can take the whole sentence.....
Just how can I enter the original sentence will only one pair of double quotes into DB2 database usinf SQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found out that's the problem with my html.....not SQL...haha