c# - Detecting and replacing all smilies in a string -

this question has answer here:

• mysql server not support 4-byte encoded utf8 characters 8 answers

i have integration facebook , have notice thay sends example u+1f600 called grinning face. when try store in mysql text field server not support 4-byte encoded fast solution remove these special chars string.

the question how? know u+1f600 suspect there more of them.

consider switching mysql utf8mb4 encoding... https://mathiasbynens.be/notes/mysql-utf8mb4