tonelm54
asked on
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE3\x80\x90Fir...' for column
I keep getting the error:-
Looking through the query it seems to be text such as:-
Im inserting the value into the query as a specified string into MySQL using PDO:-
After searching around it seems to be an issue with the charset Im using (latin1_swedish_ci - default), however I have no idea how to fix it, does anyone have any suggestion of what collation I should be using?
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE3\x80\x90Fir...' for column xxxx
Looking through the query it seems to be text such as:-
[Received email from: email@mydomain.com]
Im inserting the value into the query as a specified string into MySQL using PDO:-
$stXLS->bindValue(':description', 'Received email from: email@mydomain.com', PDO::PARAM_STR);
After searching around it seems to be an issue with the charset Im using (latin1_swedish_ci - default), however I have no idea how to fix it, does anyone have any suggestion of what collation I should be using?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER