Roundup Tracker - Issues

Message7090

Author whunger
Recipients whunger
Date 2021-03-10.14:51:14
Message-id <1615387874.91.0.944369845492.issue2551115@roundup.psfhosted.org>
In-reply-to
I just stumbled over the upgrading instructions to 2.x for MySQL users (https://www.roundup-tracker.org/docs/upgrading.html#python-2-mysql-users-must-read), to which i would like to propose an improvement.

I would not advise to set the MySQL database encoding to utf, but to utf8mb4 instead. Utf8 in MySQL is limited to use only up to 3 bytes per character, and thus cannot store all characters that you would expect maybe. Especially Emojis will not work, which is a pity, as these have a high probability of arriving through the Email interface :-)

https://stackoverflow.com/questions/30074492/what-is-the-difference-between-utf8mb4-and-utf8-charsets-in-mysql
History
Date User Action Args
2021-03-10 14:51:14whungersetrecipients: + whunger
2021-03-10 14:51:14whungersetmessageid: <1615387874.91.0.944369845492.issue2551115@roundup.psfhosted.org>
2021-03-10 14:51:14whungerlinkissue2551115 messages
2021-03-10 14:51:14whungercreate