- MySQL's JSON shared implementation completely w/ sqltypes.JSON;

this must have been an oversight.   Leave mysql.JSON in place still
as we might need to add things to it.
- CAST(json, String) still confusing MySQL drivers even mysqlclient.
Since here we're checking for the raw form of the JSON and not a typical
round trip, add a force for unicode

Change-Id: I727f4526a01a0875037cf0dede45cd074da5205a

1 files changed, 2 insertions, 2 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_types.py b/lib/sqlalchemy/testing/suite/test_types.py
index 6231e0fb9..d74ef60da 100644
--- a/lib/sqlalchemy/testing/suite/test_types.py
+++ b/lib/sqlalchemy/testing/suite/test_types.py
@@ -825,14 +825,14 @@ class JSONTest(_LiteralRoundTripFixture, fixtures.TablesTest):
         )
         eq_(
             s.query(
-                cast(self.tables.data_table.c.data, String),
+                cast(self.tables.data_table.c.data, String(convert_unicode="force")),
                 cast(self.tables.data_table.c.nulldata, String)
             ).filter(self.tables.data_table.c.name == 'd1').first(),
             ("null", None)
         )
         eq_(
             s.query(
-                cast(self.tables.data_table.c.data, String),
+                cast(self.tables.data_table.c.data, String(convert_unicode="force")),
                 cast(self.tables.data_table.c.nulldata, String)
             ).filter(self.tables.data_table.c.name == 'd2').first(),
             ("null", None)