Swap out text_as_varchar on the mssql dialect for the Types tests.

1 files changed, 6 insertions, 0 deletions

diff --git a/test/dialect/mssql.py b/test/dialect/mssql.py
index babb493ac..e6422a87a 100755
--- a/test/dialect/mssql.py
+++ b/test/dialect/mssql.py
@@ -681,6 +681,10 @@ class TypesTest2(TestBase, AssertsExecutionResults):
     def test_char(self):
         """Exercise COLLATE-ish options on string types."""
 
+        # modify the text_as_varchar setting since we are not testing that behavior here
+        text_as_varchar = testing.db.dialect.text_as_varchar
+        testing.db.dialect.text_as_varchar = False
+
         columns = [
             (mssql.MSChar, [], {},
              'CHAR'),
@@ -742,6 +746,8 @@ class TypesTest2(TestBase, AssertsExecutionResults):
             raise
         charset_table.drop()
 
+        testing.db.dialect.text_as_varchar = text_as_varchar
+
     def test_timestamp(self):
         """Exercise TIMESTAMP column."""