Users sometimes input some emoji in my BBS, but I am using MySQL version 5.0 which cannot store emoji code (as UTF).
I can not upgrade MySQL to 5.5 right now, so is there any safe way to filter the emoji code?
Users sometimes input some emoji in my BBS, but I am using MySQL version 5.0 which cannot store emoji code (as UTF).
I can not upgrade MySQL to 5.5 right now, so is there any safe way to filter the emoji code?
First, I don't know how to remove emoji code.
If you can't upgrade to mysql5.5, storing your text using the blob
type will resolve your problem.