DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: insertion with value " ' "

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    Unhappy

    Hi all,

    I tried to insert into table with value containing character " ' ", and ran into error.

    **************************************************

    SQL> insert into test values(2,'I'm good','n','n','o1-Oct-02');
    ERROR:
    ORA-01756: quoted string not properly terminated

    **************************************************

    How can I insert alone with the character " ' "? Thanks for your help!

    WU

  2. #2
    Join Date
    May 2000
    Posts
    58
    Use two single quotes before the letter m.
    insert into test values(2,'I''m good','n','n','o1-Oct-02');


  3. #3
    Join Date
    Nov 2000
    Posts
    164
    Victoria, thank you very much!

  4. #4
    Join Date
    Nov 2000
    Posts
    164
    I still have problem with the " ' ". Using " " " instead of " ' ",

    insert into test values(2,'I''m good.','n','n','01-Oct-02');

    if I do select * from test, it displays: I'm good. However, if I try to pull this data from web browser, it displays: I"m good. instead. Is there other way to insert this " ' "?

    Thanks.



  5. #5
    Join Date
    Nov 2000
    Posts
    164
    Does anyone have any suggestions?

  6. #6
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi try this

    insert into test values('I'||CHR(39)||'m good')

    where CHR(39) is '
    Cheers!
    OraKid.

Posting Permissions

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


Click Here to Expand Forum to Full Width