Smart Quotes and ascii characters

Discussion in 'Oracle' started by daiondoroga, Aug 12, 2006.

  1. daiondoroga

    daiondoroga New Member

    Joined:
    Aug 12, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    Hi!
    I need to update a VARCHAR2 column in a database and replace all occurances of a particular ascii character with another ascii character. These are not visible in the text as it's stored in the column. What functions can I use to do this type of replacement?
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Use the ASCII function. something like
    Code:
    UPDATE table-name SET column-name = ASCII('A') WHERE column-name = ASCII('B')
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice