Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Unanswered: How to insert double quote in DB2 using Putty client

    I'm trying to insert a string in DB2 with double quotes. The query executes successfully but i'm not seeing the double quotes in data stored in table.

    note : I have used '' to escape single quotes.

    Insert into Notification values (1000,'Please select a "Buy now Plan" if you''re interested in quick check out');

    The output shows

    Select * from Notification where id = 1000;

    Please select a Buy now Plan if you're interested in quick check out'




    Please help me out..
    Last edited by dineshkumar88; 11-09-16 at 11:21.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,310
    Provided Answers: 5
    Code:
    Insert into Notification values (1000,'Please select a \"Buy now Plan\" if you''re interested in quick check out')
    Andy

  3. #3
    Join Date
    Nov 2016
    Posts
    2
    Its working perfectly. Thanks a lot...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •