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?
stomataAsked:
Who is Participating?
 
askanivgConnect With a Mentor Commented:
Stomata
Have the insert statement but the inverted commas preceded by \
For e.g.

db2 "update btadstg.btt_office set off_nm='HELLO\"' where off_cd='CLOU'"

$db2 "select off_nm from btadstg.btt_office where off_cd ='CLOU'"        

OFF_NM                                            
--------------------------------------------------
HELLO"                                            


So I can have " in the column

HtH
0
 
stomataAuthor Commented:
Thx anyway,
I found out that's the problem with my html.....not SQL...haha
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.