Alembic migration that sets DB/Tables to utf8mb4
In regards to: #11 (closed)
We'd like to support case sensitivity with database transactions, which will fix the mentioned issue and additionally coincide with UNIX filesystem philosophies, which just make sense (to me, at least).
We should have an Alembic migration that performs this modification, if needed. Additionally, we should modify DB initialization to use
utf8mb4 as well, so this is never an issue after a DB is initialized before the fix migration is run.