utf8插入 mysql,MySQL UTF-8字符插入问题

I am fetching some string from facebook , but i dont know whitch encoding in string . I need to convert this string into utf8 before inserting into database table . Getting this error message.

Here is my php code.

$email = (isset($this->_userinfo['email']) ? $this->_userinfo['email'] : '');

$fname = $this->_userinfo['first_name'];

$lname = $this->_userinfo['last_name'];

$name = $this->_userinfo['name'];

$sql = 'INSERT INTO users '

. '(fbid, fbuid, fullname, userlevel, email, name, sirname) '

. 'VALUES("'

. $this->_fbid . '","'

. $fbuid . '","'

. $name . '","'

. $userlevel . '","'

. $email . '","'

. $fname . '","'

. $lname . '")';

解决方案

You might want to take a look at this question:

especially the second answer by Sebastian Grinoli

He wrote a class (and offers the link to it) which would correctly encode Windows Extended ASCII to UTF8 and also correct UTF8 if necessary.

A really handy tool to have when you are in the UTF8 land :)