PDO准备了转换单引号的语句

Question

I couldn't find clear answer for this simple(?) question.

I recently moved to PDO and I made simple insert-query:

$sql = "INSERT INTO item(name) values (:name)";
$q = $db->prepare($sql);
$q->bindParam(':name', $name);

Now, when I throw parameter "Dina's", it's apparently converted to

"Dina's" 

(or atleast this is what it seems in phpmyadmin).

Can I prevent this conversion somehow, so that data is stored as it was supplied on bindParam? Or is this current converted value the best way to have data stored?

Answer 1

This code converts nothing, you should check where $name comes from and what value it really has.