I am having an issue with inserting words with special characters into my database. The word seems to get truncated at the special character.
I am using MySQL 5.1.41 the collation on my database is utf8_general_ci. I am using PDO to facilitate database interaction.
Here is an example of what I am doing.
//$db is a PDO object
$db->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES 'utf8'");
//word with a special character
$word = "pépite";
$sql = "INSERT INTO keyword(key_name) VALUES(?)";
$stmt = $db->prepare($sql);