If you try to insert single quote into DB2 sql table directly, it will give an error message due to single quote is reserved for mark a string value in sql. It is not allowed to use escape sequence for single quote with sql. Below example is incorrect with sql syntax.
INSERT INTO CUSTOMERS ( COMPANY_NAME ) VALUES ('Nandun\'s Company')
http://lk-tech.blogspot.com/2009/06/how-to-insert-single-quote-into-db2.html
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment