Database Errors When Processing Bounces (1406 and 1366)

Recently I am seeing the following errors when processing bounces. Does anyone know how to fix this?

Processed messages will be deleted from mailbox
Database error 1406 while doing query Data too long for column ‘data’ at row 1
Database error 1366 while doing query Incorrect string value: ‘\xE9 ause…’ for column ‘header’ at row 1

The 1406 error repeats dozens of times.

I fixed the first error:
Database error 1406 while doing query Data too long for column ‘data’ at row 1

To do this I use PHPMyAdmin and opened the table phplist_bounce. I clicked the “Structure” tab, and then on the “data” row I clicked the “Change” link. I used the drop down box under “Type” and changed it from “BLOB” to “MEDIUMBLOB”.

Be sure to back up your database before doing this.

I still have this error when processing bounces, any help is appreciated:

Processed messages will be deleted from mailbox
Database error 1366 while doing query Incorrect string value: ‘\xE9 ause…’ for column ‘header’ at row 1
Database error 1366 while doing query Incorrect string value: ‘\xEAtre l…’ for column ‘header’ at row 1

This change is included in the new release.

I believe that you get that error because \xE9 isn’t valid UTF-8.

So is the 1366 error anything to worry about? I don’t recall seeing this until recently (I’ve used this for ~10 years).