Manually setting table charset for mysqlx Russian unit test

oscpache · oscpache · commit f6b6906ad553 · 2022-11-14T10:45:45.000-06:00
Change-Id: I5e5a68ce83ac9d591a07c84845ed81ea89e8e598
diff --git a/tests/test_mysqlx_crud.py b/tests/test_mysqlx_crud.py
@@ -4271,16 +4271,19 @@ class BugOra33904362(tests.MySQLxTests):
     @foreach_session()
     def test_russian_characters(self):
         table_name = "BugOra33904362"
+        charset = "utf8mb4"
 
         # create table
         self.session.sql(f"DROP TABLE IF EXISTS {table_name}").execute()
-        self.session.sql(f"CREATE TABLE {table_name}(name VARCHAR(255))").execute()
+        self.session.sql(
+            f"CREATE TABLE {table_name}(name VARCHAR(255)) DEFAULT CHARSET={charset}"
+        ).execute()
 
         # populate table
         self.session.sql(f"INSERT INTO {table_name} VALUES('света')").execute()
 
         # run query and test it
-        sql = f"SELECT name n1, name FROM {table_name} WHERE name like'све%'"
+        sql = f"SELECT name n1, name FROM {table_name} WHERE name like 'све%'"
         result = self.session.sql(sql).execute()
         res = result.fetch_one()
         self.assertEqual(res[0], "света")
