php turns string quotes to question mark

Asked Oct 25 '14 at 18:15

Active Oct 25 '14 at 19:48

Viewed 514 times

Im using php PDO and trying to insert into the DB a string in hebrew that contains quotas. It inserts the text but keeps turning the quotes('/"/`) to question marks, how can I fix that ?

the code im using:

$this->db->query("SET NAMES 'hebrew'");
         $this->db->query("set character_set_client='utf8'");
         $this->db->query("set character_set_results='utf8'");
         $this->db->query("set collation_connection='utf8'");

        $createQuery = $this->db->prepare("INSERT INTO X(Y)VALUES (:name");
        //$_POST['string'] = זאת' "בדיקה"
        $createQuery->bindParam("name",$_POST['string']);

        $createQuery->execute();

Thanks!

edited Oct 25 '14 at 19:48

asked Oct 25 '14 at 18:15

gilm501

3

I have no idea; no code makes it that much more harder to tell. – Funk Forty Niner Oct 25 '14 at 18:18
Without seeing the code, I can only assume it's an encoding issue. – Slava Knyazev Oct 25 '14 at 18:19
please, post your queries – Oct 25 '14 at 18:19
Forgot to add the code, edited. – gilm501 Oct 25 '14 at 19:19
The `?` characters are displaying in your browser output? You may have the wrong output encoding. See [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) to make sure you have all the pieces in place. – Michael Berkowski Oct 25 '14 at 19:38
please provide sample input - or even better, get rid of `$_POST`. – Karoly Horvath Oct 25 '14 at 19:44
@MichaelBerkowski the ? are displayed in phpMyAdmin. – gilm501 Oct 25 '14 at 19:49
1

Take a look at this: http://stackoverflow.com/questions/7822461/pdo-utf-8-character-issue Hope it helps – bestprogrammerintheworld Oct 25 '14 at 19:53

php turns string quotes to question mark

0 Answers0