Link to home
Start Free TrialLog in
Avatar of stomata
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?
ASKER CERTIFIED SOLUTION
Avatar of askanivg
askanivg

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of stomata
stomata

ASKER

Thx anyway,
I found out that's the problem with my html.....not SQL...haha