Replacing non-ASCII quotations from an SQL database in PHP

Asked Jan 16 '18 at 05:23

Active Jan 16 '18 at 07:04

Viewed 26 times

I have some text data in an SQL database that consists of weird quotations that appear as � on a webpage.

The quotations are these non ascii ” style quotes instead of the normal "

I tried to do

$text = str_replace('”', '"', $text);

But it seems to have no effect. Does anyone know how I can handle this?

edited Jan 16 '18 at 07:04

Jeff

asked Jan 16 '18 at 05:23

Aro

I found this blog http://shiflett.org/blog/2005/convert-smart-quotes-with-php , it may be helpful for you. – Long Kim Jan 16 '18 at 05:27
4

I smell a utf8 all the way dupe closure coming – mickmackusa Jan 16 '18 at 05:27
Long Kim - thanks that worked. mickmackusa - what's that? – Aro Jan 16 '18 at 05:34
https://stackoverflow.com/questions/279170/utf-8-all-the-way-through – mickmackusa Jan 16 '18 at 05:51

0 Answers0