diff options
| author | Gord Thompson <gord@gordthompson.com> | 2019-12-03 17:41:56 -0700 |
|---|---|---|
| committer | Gord Thompson <gord@gordthompson.com> | 2019-12-03 17:41:56 -0700 |
| commit | 9592a7afccc5ed0a245b0fca6ad34e748a38336a (patch) | |
| tree | 2bd2413c6d9535e0aa0cb61556317a2ae7211a71 /lib/sqlalchemy/dialects/mysql/pyodbc.py | |
| parent | 380f4389922004589bfa7cb4f9b8c8208aa68659 (diff) | |
| download | sqlalchemy-9592a7afccc5ed0a245b0fca6ad34e748a38336a.tar.gz | |
Add note re: using the MySQL ODBC "ANSI" driver for mysql+pyodbc.
Diffstat (limited to 'lib/sqlalchemy/dialects/mysql/pyodbc.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/pyodbc.py | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/pyodbc.py b/lib/sqlalchemy/dialects/mysql/pyodbc.py index 0da5a8eaf..c533595bb 100644 --- a/lib/sqlalchemy/dialects/mysql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mysql/pyodbc.py @@ -14,11 +14,16 @@ :connectstring: mysql+pyodbc://<username>:<password>@<dsnname> :url: http://pypi.python.org/pypi/pyodbc/ - .. note:: The PyODBC for MySQL dialect is not well supported, and - is subject to unresolved character encoding issues - which exist within the current ODBC drivers available. - (see http://code.google.com/p/pyodbc/issues/detail?id=25). - Other dialects for MySQL are recommended. +.. note:: + + The PyODBC for MySQL dialect is **not tested as part of + SQLAlchemy's continuous integration**. + The recommended MySQL dialects are mysqlclient and PyMySQL. + However, if you want to use the mysql+pyodbc dialect and require + full support for ``utf8mb4`` characters (including supplementary + characters like emoji) be sure to use a current release of + MySQL Connector/ODBC and specify the "ANSI" (**not** "Unicode") + version of the driver in your DSN or connection string. """ |