如何替换utf8_general_ci上的所有无效字符

Question

How to replace all non valid characters on utf8_general_ci?

For mysql inserts without problems if user can put emojis or another misc. characters but maintains all compatible characters (a-Z, numbers, characters, quotes, russian text, japan text...)

Thanks.

Answer 1

In PHP you can use the function utf8_encode() to make sure only valid caracters are in the provided string.

Note: in MySQL 5.5.3 and up use utf8mb4, rather than utf8, which is the same UTF-8 data format with the same performance but removes a MySQL-specific limitation where only characters up to xFFFD were supported.

If you need some more flexibility or other charsets take a look at iconv(). It´s not maintained any more but at least changes in charsets are rare ;-)