Make sure character set of events, states tables is utf8 (#56012)
Make sure character set of events, states tables is utf8 (#56012)

* Make sure character set of events, states tables is utf8

* Pylint

* Apply suggestions from code review
GenericStudent/home-assistant,mezz64/home-assistant,rohitranjan1991/home-assistant,aronsky/home-assistant,nkgilley/home-assistant,Danielhiversen/home-assistant,GenericStudent/home-assistant,toddeye/home-assistant,toddeye/home-assistant,home-assistant/home-assistant,nkgilley/home-assistant,jawilson/home-assistant,aronsky/home-assistant,Danielhiversen/home-assistant,lukas-hetzenecker/home-assistant,w1ll1am23/home-assistant,home-assistant/home-assistant,mezz64/home-assistant,w1ll1am23/home-assistant,lukas-hetzenecker/home-assistant,rohitranjan1991/home-assistant,jawilson/home-assistant,rohitranjan1991/home-assistant