Re: mysqlIndexerTest.test_unicode fails for me

On Thu, 30 Apr 2020, Ralf Schlatterbeck wrote:

> On Thu, Apr 30, 2020 at 12:52:38PM +0000, Joseph Myers wrote:
> > 
> > That condition was so that a database created with older Roundup, with 
> > Python 2, continues to work properly with newer Roundup, with Python 2.  
> > (I couldn't get such a database to work with Python 3, hence the 
> > documentation of needing to export and import when moving to Python 3 with 
> > MySQL.)
> 
> I see, how about making the database encoding for mysql a config-item
> which defaults to utf-8 and stating in the documentation for people
> upgrading that they have to set this if they have a different database
> encoding? I'd voluteer to do that if someone looks over my documentation
> :-)

Note that the "latin1" default doesn't really mean latin1, it means UTF-8 
bytes which MySQL treats as if they were latin1 (and which I couldn't get 
working with Python 3).  So there would be the issue of defining exactly 
what such a configuration setting means and exactly what does or doesn't 
work for upgrades of Roundup or Python version.

-- 
Joseph S. Myers
[email protected]