PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value

By WhiplashInfo on 8 Feb 2012 at 08:07 UTC

Can a moderator remove this item? I posted at the wrong site, by misstake and can't erease this item.
Thanks / Tomas

Comments

klucid commented 9 February 2012 at 20:05

I'm having the same issue.

aarsic commented 8 October 2012 at 15:03

I also get this error trying to post a new article: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value:

Anyone know what it means?

taskjo commented 14 February 2013 at 17:07

Same problem. I am running 7.x distribution of recruiter and the error happens on new user trying to register.

purabdk commented 31 July 2013 at 06:12

It issue happen when character set is not in UTF-8 format.
If you got the error while using the db_insert then you can use the following code

$val = mb_check_encoding($val, 'UTF-8') ? $val : utf8_encode($val);

if it is just matter of some field values.