GoFuckYourself.com - Adult Webmaster Forum - View Single Post - How do I convert the Microsoft Word apostrophe to an HTML friendly apostrophe?

zentz · 10-17-2008, 04:39 PM

i tried this

update wp_posts set post_content = replace(post_content,'''', ''')

as funky apostrophe is showing as '' in mysql.

the error i get is:

ERROR: Unclosed quote @ 62
STR: '
SQL: update wp_posts set post_content = replace(post_content,'''', ''')

when i try to replace it with something else then ''' , example 'fuck' it works fine. any ideas?

10-17-2008, 04:39 PM
zentz Confirmed User Industry Role: Join Date: Nov 2003 Posts: 8,053	i tried this update wp_posts set post_content = replace(post_content,'''', ''') as funky apostrophe is showing as '' in mysql. the error i get is: ERROR: Unclosed quote @ 62 STR: ' SQL: update wp_posts set post_content = replace(post_content,'''', ''') when i try to replace it with something else then ''' , example 'fuck' it works fine. any ideas? __________________ Programs that owe me money ---- Epassporte.com ~ $2700 \| Protraffic.com ~ $2600 \| XonDemand.com ~ $3000 Email: [email protected]