Artjom Kurapov Artjom Kurapov - 1 year ago 340
JSON Question

json_encode(): Invalid UTF-8 sequence in argument

I'm calling

on data that comes from a MySQL database with
collation. The problem is that some rows have weird data which I can't clean. For example symbol
, so once it reaches
, it fails with
json_encode(): Invalid UTF-8 sequence in argument

I've tried
, even with
but it keeps getting through and causing havoc.

Running PHP 5.3.10 on Mac. So the question is - how can I clean up invalid utf8 symbols, keeping the rest of data, so that
would work?

Update. Here is a way to reproduce it:

echo json_encode(pack("H*" ,'c32e'));

Answer Source

Seems like the symbol was Å, but since data consists of surnames that shouldn't be public, only first letter was shown and it was done by just $lastname[0], which is wrong for multibyte strings and caused the whole hassle. Changed it to mb_substr($lastname, 0, 1) - works like a charm.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download