How do I replace this character using PHP?

Question

The character comes from an XML feed.

Here is an excerpt:

Kock’s parole

As you see, it is not a normal '

We tried

$sql = str_replace("’", "\'", $sql);

But that does nothing.

Any ideas?

What exactly is `$sql`? Raw text? Do you know what encoding it's in? — Jon, Jul 11 '14 at 10:58
http://stackoverflow.com/questions/14743812/how-to-use-str-replace-to-replace-single-and-double-quotes — sumit, Jul 11 '14 at 10:58
@Jacques: Why is it called `$sql` if it's XML? Anyway, if it's XML then the encoding has to be already known. What is that encoding? UTF-8? What encoding is your source code saved in? — Jon, Jul 11 '14 at 11:36

score 0 · Answer 1 · answered Jul 11 '14 at 11:02

0

Try to replace

$sql = str_replace("’", "\'", $sql);

with

$sql = str_replace("’", "'", $sql);

answered Jul 11 '14 at 11:02

Branimir Đurek

score 0 · Answer 2 · answered Jul 11 '14 at 11:04

0

Try this:

$sql = str_replace( chr(146), "\'", $sql);

answered Jul 11 '14 at 11:04

Shub

score 0 · Answer 3 · answered Jul 11 '14 at 11:08

I think if this is an sql statement, you will have to do something like this:

$sql = str_replace("’", "\\\'", $sql);

So for example if you sql statement is something like this:

$name = "Kock’s parole";
$name = str_replace("’", "\\\'", $name);
$sql = "INSERT INTO users (`name`) VALUES ('$name')";

then this will work fine for you.

3 Answers3