diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-05-03 08:58:27 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-05-03 09:00:00 -0400 |
| commit | 4abca61b4903e42f9568cc06f3c18ac27a139cf7 (patch) | |
| tree | ad0eeab5b65cf63cc6b367ad2593a052e00e412a /lib/sqlalchemy/dialects/mysql/pyodbc.py | |
| parent | 889cbe53121c8fd50c845357dd52b24594346b68 (diff) | |
| download | sqlalchemy-4abca61b4903e42f9568cc06f3c18ac27a139cf7.tar.gz | |
bypass pyodbc default server version / set charset
Further adjustments to the MySQL PyODBC dialect to allow for complete
connectivity, which was previously still not working despite fixes in
:ticket:`7871`.
Fixes: #7966
Change-Id: I549ea9e7b6e722e22d3e25bdb2fe0934603e2454
Diffstat (limited to 'lib/sqlalchemy/dialects/mysql/pyodbc.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/pyodbc.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/pyodbc.py b/lib/sqlalchemy/dialects/mysql/pyodbc.py index 28dafc5a0..2d31dfe5f 100644 --- a/lib/sqlalchemy/dialects/mysql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mysql/pyodbc.py @@ -90,6 +90,9 @@ class MySQLDialect_pyodbc(PyODBCConnector, MySQLDialect): # # If it's decided that issuing that sort of SQL leaves you SOL, then # this can prefer the driver value. + + # set this to None as _fetch_setting attempts to use it (None is OK) + self._connection_charset = None try: value = self._fetch_setting(connection, "character_set_client") if value: @@ -103,6 +106,9 @@ class MySQLDialect_pyodbc(PyODBCConnector, MySQLDialect): ) return "latin1" + def _get_server_version_info(self, connection): + return MySQLDialect._get_server_version_info(self, connection) + def _extract_error_code(self, exception): m = re.compile(r"\((\d+)\)").search(str(exception.args)) c = m.group(1) |