add section to engines.rst how to urlencode special chars in passwords

[ronlut]

Hi.

Our password (generated by MySQL) contains a percent (%) symbol.

The _rfc_1738_unquote function, called by _parse_rfc1738_args in the process of creating an engine, replaces the percent symbol (and the character following it) with another symbol, making the password impossible to encode into latin-1 by the pymysql driver later on.

In our example, %8 turns into some unicode character I guess:

Is that a bug or is that by design?
If that's not a bug, what can I do to deal with it? Except changing the password.

Thanks

[zzzeek]

hi there -

you need to use urlencoding for special characters in the URL (because it's a URL), so a password like "my%password" should be passed as "my%25password".

please let me know that resolves your issue.

looks like we need some documentation for this since I can't find it.

[ronlut]

Yeah,

urllib.parse.quote(PASSWORD) works

Thanks :)

[zzzeek]

quote_plus is better