strange chars from form to database â€œlikeâ€ a

Question

I am getting these chars as I insert into a database: â€œlikeâ€. Its suppose to be "like" but it comes out that way.

It inserts into the database that way from a form I submit. I tried htmlspecialchars and addslashes but this did not work.

I am sure this is a simple fix. Just cant find it.

Thanks

UPDATE: I noticed that the funny chars come from the quotes that Microsoft Word makes. I used this code and it worked... for now.

$Comments = $_POST[Comments];
$Comments = str_replace("”", "\"", $Comments);
$Comments = str_replace("“", "\"", $Comments);

I don't know how to tell. I had wordpress set it up. I had this issue before. — Papa De Beau, Oct 12 '13 at 23:57

score 3 · Answer 1 · answered Oct 12 '13 at 23:58

3

You probably want to support Unicode characters throughout your app:

answered Oct 12 '13 at 23:58

Matt S

score 0 · Answer 2 · answered Oct 12 '13 at 23:59

0

Change your database encoding to UTF-8. This link could be helpful http://sudarmuthu.com/blog/wordpress-and-mysql-character-encoding

answered Oct 12 '13 at 23:59

fasouto

I did your change in the database but it didn't work for the word quotes. See my post above. I updated it. That works for those but I don't know what other chars I might have issues with. – Papa De Beau Oct 13 '13 at 01:16
Ok, glad you solve it. BTW, I've found a similar thread in SO http://stackoverflow.com/a/12252899/263989 – fasouto Oct 13 '13 at 02:07

2 Answers2