That sounds like a recipe for disaster if you aren’t careful with database charsets and collations.
A couple of years ago I started working on it, but it’s unfinished and out-of-date. Anyway, maybe it will be helpful.
https://github.com/discourse/discourse/commit/784418a36b301d2edf9cc8412809ee820ce60061