1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    Likes Received:
    364
    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