Detecting and replacing all smilies in a string

Question

I have a integration with facebook and have notice that thay sends for example u+1f600 that is called a grinning face. When I try to store this in the MySQL Text field I get Server does not support 4-byte encoded so a fast solution is to remove all these special chars from the string.

The question is how? I know about the u+1f600 but I suspect that there could be more of them.

I would have suggest to use regex to remove 4-byte encoding in a string. if you were using php this would be perfect for you: http://stackoverflow.com/a/16496730/761312 — D_R, Mar 16 '15 at 20:30

score 2 · Accepted Answer · answered Mar 16 '15 at 20:30

2

Consider switching to MySQL utf8mb4 encoding... https://mathiasbynens.be/notes/mysql-utf8mb4

answered Mar 16 '15 at 20:30

Rufus L

36,127
5
30
43

Detecting and replacing all smilies in a string

1 Answers1