Character set in MySQL; Can't insert special characters, why?

Question

I cannot insert special characters. Whenever I try, all characters BEFORE adding a special character, but nothing is entered into the field after the special character.

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql'); mysql_select_db($dbname,$conn); mysql_set_charset('utf-8', $conn); mysql_query("SET NAMES 'utf8'") or die(mysql_error()); mysql_query("SET CHARACTER SET 'utf8'") or die(mysql_error()); 

I set up a table to sort utf-8 and all fields ...

Any thoughts?

thanks

Answer 1

Have you set UTF-8 parameters in your PHP configuration? I used to start with PHP files:

  ini_set("mbstring.internal_encoding","UTF-8"); ini_set("mbstring.func_overload",7);