i am getting the following error when inserting a specific record into the database:
PHP Fatal error: 1366:Incorrect string value: '\xA0east ...' for column `paypal`.`address_state`
the collation for the paypal table is utf8mb4_unicode_ci. the same for the address_state field in the table.
i am not able to reproduce the error as the formatting of the error log is probably changing the actual bytes coming back from paypal.
in looking at the paypal functions, i see we are just accepting whatever is posted back to the handler.
in includes/modules/payment/paypal/paypal_functions.php i have tried:
PHP Code:
'address_state' => zen_db_prepare_input(preg_replace('/\xc2\xa0/i', ' ', $_POST['address_state'])),
but that does not seem to address this issue.
i am open to any ideas.
thanks in advance.
Bookmarks