Fix most of the tests when run in MySQL

Adding SOUTH_TESTS_MIGRATION = False causes the number of failing tests to go from dozens to only 3.

Setting the default collation to be utf-8 for MySQL fixes one of the tests. After this fix, only 2 tests fail.