emoji in forms rise a database error
- Dominant language
- PHP
- Stars
- 52
- Forks
- 54
- PR merge metrics
- No merged PRs in 30d
Description
If you choose to save form submissions to the database and the user puts some emoji in their name or message, it leads to a fatal error "incorrect string value ... for column". Changing the table's charset to utf8mb4 doesn't help, apparently, it requires the whole database's charset to be set to that. But Bolt's default charset is regular utf8. If Bolt team is not going to change their charset to that (I suppose they're not), then BoltForms must sanitize input. I had to make an extension that uses the regex from there: https://stackoverflow.com/a/35961386/2418445. But you should consider including this by default.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.