<p>Does anyone know a SQL command to replace MS Office smart quotes with their ASCII cousins? I'm using an oracle database and the fields are of type varchar2</p>

<pre class="prettyprint"><code>REPLACE(REPLACE(str, '`', ''''), '´', '''') </code></pre> <p>Or am I missing your question?</p>

SQL to replace smart quotes

update table set column = replace(replace(column, chr(147),'"'), chr(148), '"')

101

answered Oct 17 '22 12:10

REPLACE(REPLACE(str, '`', ''''), '´', '''')

Or am I missing your question?

answered Oct 17 '22 13:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!