@BeforeAll
    static void setup() throws SQLException {
        try (final Connection connection = getConnection()) {
            try (final PreparedStatement preparedStatement = connection.prepareStatement(
                    "DROP TABLE IF EXISTS CHAR_SET_TEST")) {
                preparedStatement.execute();
            }
            try (final PreparedStatement preparedStatement = connection.prepareStatement(
                    "CREATE TABLE IF NOT EXISTS CHAR_SET_TEST (TXT VARCHAR(255)) " +
                            "ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=latin1")) {
                preparedStatement.execute();
            }
        }
    }
Test class to explore issues with character sets between Java and MySql.
Currently ignored as most of the tests require human oversight. Left in, in
case it proves useful.
stroom-statistics/stroom-statistics-impl-sql/src/test/java/stroom/statistics/impl/sql/TestMySQLCharacterSets.java