diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-03-28 11:20:22 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2010-03-28 11:20:22 -0400 |
| commit | 8f11ca9a6a5fdbb020ad35e2477ac77811485fbb (patch) | |
| tree | 41f912ad186dd02306f029c4babe81090a2ffd8e /lib/sqlalchemy/dialects/mysql/mysqldb.py | |
| parent | 0ee5899743dc5b56fabcd9ab1198b2bb969ac5ff (diff) | |
| download | sqlalchemy-8f11ca9a6a5fdbb020ad35e2477ac77811485fbb.tar.gz | |
documentation updates
Diffstat (limited to 'lib/sqlalchemy/dialects/mysql/mysqldb.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mysql/mysqldb.py | 28 |
1 files changed, 26 insertions, 2 deletions
diff --git a/lib/sqlalchemy/dialects/mysql/mysqldb.py b/lib/sqlalchemy/dialects/mysql/mysqldb.py index 9d34939a1..6e6bb0ecc 100644 --- a/lib/sqlalchemy/dialects/mysql/mysqldb.py +++ b/lib/sqlalchemy/dialects/mysql/mysqldb.py @@ -1,5 +1,18 @@ """Support for the MySQL database via the MySQL-python adapter. +MySQL-Python is available at: + + http://sourceforge.net/projects/mysql-python + +At least version 1.2.1 or 1.2.2 should be used. + +Connecting +----------- + +Connect string format:: + + mysql+mysqldb://<user>:<password>@<host>[:<port>]/<dbname> + Character Sets -------------- @@ -14,10 +27,21 @@ enabling ``use_unicode`` in the driver by default. For regular encoded strings, also pass ``use_unicode=0`` in the connection arguments:: # set client encoding to utf8; all strings come back as unicode - create_engine('mysql:///mydb?charset=utf8') + create_engine('mysql+mysqldb:///mydb?charset=utf8') # set client encoding to utf8; all strings come back as utf8 str - create_engine('mysql:///mydb?charset=utf8&use_unicode=0') + create_engine('mysql+mysqldb:///mydb?charset=utf8&use_unicode=0') + +Known Issues +------------- + +MySQL-python at least as of version 1.2.2 has a serious memory leak related +to unicode conversion, a feature which is disabled via ``use_unicode=0``. +The recommended connection form with SQLAlchemy is:: + + engine = create_engine('mysql://scott:tiger@localhost/test?charset=utf8&use_unicode=0', pool_recycle=3600) + + """ import re |
