Fix character set for post signature column on MySQL / MariaDB instances

Previously, we never specified the character set, and it seemed to default to
utf8mb3 instead of utf8mb4, which caused issues when updating the value if,
for example, the signature contained emoji.

Fixes #1572