Database Itself  config change:

See:

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html

https://www.google.com/search?client=firefox-b-1-d&q=Warning%3A+%283719%2C+u%22%27utf8%27+is+currently+an+alias+for+the+character+set+UTF8MB3%2C+but+will+be+an+alias+for+UTF8MB4+in+a+future+release.+Please+consider+us


*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Tue, Feb 19, 2019 at 11:51 PM Andrea Fae' <and...@gmail.com> wrote:

> Hello, why I have this warning?
>
> c:\web2py>python web2py.py -S ga2 -M -P
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2019
> Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
> Database drivers available: pymysql, imaplib, sqlite3, pg8000, pyodbc,
> mysqlconnector
> C:\Python27\lib\site-packages\pymysql\cursors.py:170:* Warning: (3719,
> u"'utf8' is currently an alias for the character set UTF8MB3, but will be
> an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in
> order to be unambiguous.")*
>   result = self._query(query)
> Python 2.7.14 (v2.7.14:84471935ed, Sep 16 2017, 20:25:58) [MSC v.1500 64
> bit (AMD64)] on win32
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
>
> I specified this in the appcoonfig.ini
>
> mysql://root:passwordroot@localhost/ga2db?set_encoding=utf8mb4
>
> If I don't specify ?set_encoding=utf8mb4 the warning is the same
> mysql is 8.0.15...
>
> thank you
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to