Menu
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
264
update table set column = replace(replace(column, chr(147),'"'), chr(148), '"')
101
REPLACE(REPLACE(str, '`', ''''), '´', '''')
Or am I missing your question?
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
