diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-03-20 12:07:00 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-03-20 12:07:00 -0400 |
| commit | 834973092c1b763a4c67da9797a398981ac449ea (patch) | |
| tree | 3d8b1ec476f847294a2679ac13fcc98331cb1c35 /lib/sqlalchemy/dialects/mysql/mysqldb.py | |
| parent | 2feb40d0a48dd424c38a37e70a63a6bcf3c00c02 (diff) | |
| parent | 6e8ecd161bfb95b39713ba406921fb277b2802a3 (diff) | |
| download | sqlalchemy-834973092c1b763a4c67da9797a398981ac449ea.tar.gz | |
Merge branch 'support-emoji-on-mysql' of https://bitbucket.org/graingert/sqlalchemy into pr49
Diffstat (limited to 'lib/sqlalchemy/dialects/mysql/mysqldb.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/mysqldb.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/mysqldb.py b/lib/sqlalchemy/dialects/mysql/mysqldb.py index 0d125a245..a65f69622 100644 --- a/lib/sqlalchemy/dialects/mysql/mysqldb.py +++ b/lib/sqlalchemy/dialects/mysql/mysqldb.py @@ -28,6 +28,18 @@ unicode** will include both charset and use_unicode=0:: create_engine("mysql+mysqldb://user:pass@host/dbname?charset=utf8&use_unicode=0") +For MySQL versions 5.5.3 and MySQLdb version 1.2.3 forward, the special +MySQL-specific encoding 'utf8mb4' is now recommended:: + + create_engine("mysql+mysqldb://user:pass@host/dbname?charset=utf8mb4&use_unicode=0") + +The 'utf8' encoding may still be used, however MySQL will only support +unicode characters within the first three of four possible bytes: +no (💩 or 😻) note that in order to use utf8mb4 fully, changes to +the MySQL schema and/or server configuration may be required. +See also: `The utf8mb4 character set +<http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html>_`. + As of this writing, MySQLdb only runs on Python 2. It is not known how MySQLdb behaves on Python 3 as far as unicode decoding. |