Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    12

    Unanswered: insert of special characters

    Hi all,
    I'm faced with following issue, when I do an update of a columns with following statement
    update table set col1 ='my new value's have special character' I will get message ora-00933 telling me that sql statement not ended properly.

    Can anybody point me to correct typing of that statement.

    Many thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    You have to use double apostroph:

    update table set col1 ='my new value''s have special character'

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Use

    update table set col1 ='my new value''s have special character'

    When you have a single quote within a string, you must use 2 single quotes to indicate to the parser that you are not terminating the string
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Quote Originally Posted by einfachtom
    'my new value's have special character'
    ...
    Can anybody point me to correct typing of that statement.
    Actually, it would be:

    'my new values have special character'

    Apostrophes are not used to pluralise nouns.

    I am starting to sound like the Phantom Nitpicker now...

  5. #5
    Join Date
    Aug 2004
    Posts
    12
    Great - this was solution.

    Many thanks

Posting Permissions

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