public class Test1 {

@Test
public void test() throws SQLException {
try (Connection conn = DriverManager.getConnection("jdbc:mariadb://localhost/test?characterEncoding=UTF-8", "root", "root")) {
conn.prepareStatement("CREATE TABLE table1 (column1 blob ) DEFAULT CHARSET=utf8").execute();
String str = "\u4f60\u597d(hello in Chinese)";
try {
try (PreparedStatement ps = conn.prepareStatement("insert into table1 values"))

{ ps.setString(1, str); ps.executeUpdate(); }

try (PreparedStatement ps = conn.prepareStatement("select * from table1");
ResultSet rs = ps.executeQuery()) {
while (rs.next())

{ String tmp = rs.getString(1); assertEquals(tmp, str); }

}
} finally

{ conn.prepareStatement("DROP TABLE IF EXISTS table1").execute(); }

}
}
}