On Tue, Mar 13, 2018 at 8:26 PM,  <[email protected]> wrote:
> Confirmed: adding `binary_prefix=true` to the URL gets rid of the warning.
>
> I’ll also keep an eye out for SA1.3, and will remove that string then.


im going to make it look for the option so shouldn't break for you.


>
> Thanks Mike!
>
>
> On Tuesday, March 13, 2018 at 11:57:52 PM UTC+10, Mike Bayer wrote:
>>
>> OK I have better news.    pymysql already did the thing I wanted him to
>> do, apparently, so connect like this:
>>
>> e =
>> create_engine("mysql+pymysql://scott:tiger@mysql57/test?charset=utf8mb4&binary_prefix=true",
>> echo=True)
>>
>> warning should be gone.
>>
>> However, I'm going to implement the _binary prefix for all drivers in 1.3
>> as part of
>> https://bitbucket.org/zzzeek/sqlalchemy/issues/4216/mysql-specific-binary-warnings-1300
>> .
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
<div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 13,
2018 at 8:26 PM,  <span dir="ltr">&lt;<a
href="mailto:[email protected]";
target="_blank">[email protected]</a>&gt;</span>
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div
dir="ltr">Confirmed: adding `binary_prefix=true` to the URL gets rid
of the warning.<div><br></div><div>I’ll also keep an eye out for
SA1.3, and will remove that string
then.</div><div><br></div><div>Thanks Mike!</div><span
class=""><div><br><br>On Tuesday, March 13, 2018 at 11:57:52 PM
UTC+10, Mike Bayer wrote:<blockquote class="gmail_quote"
style="margin:0;margin-left:0.8ex;border-left:1px #ccc
solid;padding-left:1ex"><div dir="ltr"><div><div><div>OK I have better
news.&nbsp;&nbsp;&nbsp; pymysql already did the thing I wanted him to
do, apparently, so connect like this:<br><br></div>e =
create_engine("mysql+pymysql:/<wbr>/scott:tiger@mysql57/test?char<wbr>set=utf8mb4&amp;binary_prefix=true<wbr>",
echo=True)<br><br></div>warning should be gone.<br><br></div>However,
I'm going to implement the _binary prefix for all drivers in 1.3 as
part of <a 
href="https://bitbucket.org/zzzeek/sqlalchemy/issues/4216/mysql-specific-binary-warnings-1300";
rel="nofollow" target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=en&amp;q=https://bitbucket.org/zzzeek/sqlalchemy/issues/4216/mysql-specific-binary-warnings-1300&amp;source=gmail&amp;ust=1521128400410000&amp;usg=AFQjCNGQMeaVq9_33yF1g9sY8aabSifscQ";>https://bitbucket.org/zzzeek/s<wbr>qlalchemy/issues/4216/mysql-sp<wbr>ecific-binary-warnings-1300</a>
.</div>
</blockquote></div></span></div>

<p></p>

-- <br><div class="HOEnZb"><div class="h5">
SQLAlchemy - <br>
The Python SQL Toolkit and Object Relational Mapper<br>
&nbsp;<br>
<a href="http://www.sqlalchemy.org/"; target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=en&amp;q=http://www.sqlalchemy.org/&amp;source=gmail&amp;ust=1521128400410000&amp;usg=AFQjCNEAdXbILFsqqNSz9ik6yFKiVqg40Q";>http://www.sqlalchemy.org/</a><br>
&nbsp;<br>
To post example code, please provide an MCVE: Minimal, Complete, and
Verifiable Example.  See  <a href="http://stackoverflow.com/help/mcve";
target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=en&amp;q=http://stackoverflow.com/help/mcve&amp;source=gmail&amp;ust=1521128400410000&amp;usg=AFQjCNEH7bdJAs2PcjMTSS10ue4zpP66bQ";>http://stackoverflow.com/help/<wbr>mcve</a>
for a full description.<br>
--- <br>
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.<br>
To unsubscribe from this group and stop receiving emails from it, send
an email to <a href="mailto:[email protected]";
target="_blank">sqlalchemy+unsubscribe@<wbr>googlegroups.com</a>.<br>
To post to this group, send email to <a
href="mailto:[email protected]";
target="_blank">[email protected]</a>.<br>
Visit this group at <a
href="https://groups.google.com/group/sqlalchemy"; target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=en&amp;q=https://groups.google.com/group/sqlalchemy&amp;source=gmail&amp;ust=1521128400410000&amp;usg=AFQjCNFyOk1whxI1p5zwWVRN9EqWiBITiQ";>https://groups.google.com/<wbr>group/sqlalchemy</a>.<br>
For more options, visit <a href="https://groups.google.com/d/optout";
target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=en&amp;q=https://groups.google.com/d/optout&amp;source=gmail&amp;ust=1521128400410000&amp;usg=AFQjCNGxfA2BWpSeXk0KYvqOT9DdcRv3Eg";>https://groups.google.com/d/<wbr>optout</a>.<br>
</div></div></blockquote></div><br></div>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to