Go4Expert - Smart Quotes and ascii characters

Go4Expert (http://www.go4expert.com/)

- Oracle (http://www.go4expert.com/forumdisplay.php?f=39)

- - Smart Quotes and ascii characters (http://www.go4expert.com/showthread.php?t=1181)

daiondoroga

12Aug2006 19:57

Smart Quotes and ascii characters

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?

shabbir

13Aug2006 08:30

Re: Smart Quotes and ascii characters

Use the ASCII function. something like

Code: SQL

UPDATE table-name SET column-name = ASCII('A') WHERE column-name = ASCII('B')

All times are GMT +5.5. The time now is 09:16.