Fix MySQL error Cdbcommand failed to execute the SQL statement:sqlstate[hy000]: General error:1300 Invalid UTF8 character str ing: ' \xbf\xa5 '

Error:

Cdbcommand failed to execute the SQL statement:sqlstate[hy000]: General error:1300 Invalid UTF8 character string: ' \xbf\ XA5 '

Workaround:

$currentPrice = $currentPrice  * 1;  

= = $currentPrice A number that was originally a string, resulting in a failure to insert the database.

= "So just change it to a  number."

But there are reports of a PHP error:

Internal Server Errordivision by zero

An internal error occurred while the WEB server is processing your request. Please contact the webmaster to report this problem.





Thank.



Turn On Error message validation first:ini_set(‘display_errors‘,‘on‘);

error_reporting(E_ALL);

Fix MySQL error Cdbcommand failed to execute the SQL statement:sqlstate[hy000]: General error:1300 Invalid UTF8 character str ing: ' \xbf\xa5 '