From 3d19fb6d53c2aa0fdb7944569fa697c75785634c Mon Sep 17 00:00:00 2001 From: LunarShaddow Date: Mon, 8 May 2017 12:31:50 +0800 Subject: [PATCH] Break the lines to fit pdf and fix another broken syntax --- lib/sqlalchemy/dialects/mysql/base.py | 16 ++++++++++------ 1 file changed, 10 insertions(+), 6 deletions(-) diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index f1d779e0df..21d325d0ca 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -205,7 +205,8 @@ Most MySQL DBAPIs offer the option to set the client character set for a connection. This is typically delivered using the ``charset`` parameter in the URL, such as:: - e = create_engine("mysql+pymysql://scott:tiger@localhost/test?charset=utf8") + e = create_engine( + "mysql+pymysql://scott:tiger@localhost/test?charset=utf8") This charset is the **client character set** for the connection. Some MySQL DBAPIs will default this to a value such as ``latin1``, and some @@ -223,7 +224,8 @@ that includes codepoints more than three bytes in size, this new charset is preferred, if supported by both the database as well as the client DBAPI, as in:: - e = create_engine("mysql+pymysql://scott:tiger@localhost/test?charset=utf8mb4") + e = create_engine( + "mysql+pymysql://scott:tiger@localhost/test?charset=utf8mb4") At the moment, up-to-date versions of MySQLdb and PyMySQL support the ``utf8mb4`` charset. Other DBAPIs such as MySQL-Connector and OurSQL @@ -235,8 +237,8 @@ the MySQL schema and/or server configuration may be required. .. seealso:: `The utf8mb4 Character Set \ -`_ - \ -in the MySQL documentation + `_ - \ + in the MySQL documentation Unicode Encoding / Decoding ~~~~~~~~~~~~~~~~~~~~~~~~~~~ @@ -257,7 +259,8 @@ DBAPI's handling of unicode, such that it instead will return data of the ``str`` type or ``bytes`` type, with data in the configured charset:: # connect while disabling the DBAPI's unicode encoding/decoding - e = create_engine("mysql+mysqldb://scott:tiger@localhost/test?charset=utf8&use_unicode=0") + e = create_engine( + "mysql+mysqldb://scott:tiger@localhost/test?charset=utf8&use_unicode=0") Current recommendations for modern DBAPIs are as follows: @@ -406,7 +409,8 @@ storage engine. .. seealso:: - `CREATE INDEX `_ - MySQL documentation + `CREATE INDEX `_ - \ + MySQL documentation Index Types ~~~~~~~~~~~~~ -- 2.39.5