[Roundup-users] Calling all Roundup MySQL users - charset/collation changes

[John P. R. <ro...@cs...>]

Hi Everybody:

MySQL has had a checkered past with supporting UTF8 charsets.  Roundup
has shared that challenge. The utf8mb4 preferred by Roundup since
2022, has some issues. This includes the crashes reported by Nagy
Gabor when Roundup mixes utf8mb4 charsets with incompatible
collations. This latest patch hopefully fixes all of those and chooses
the best defaults while letting you fall back to older charsets.

It also include instructions on converting the underlying database
from whatever encoding/collation to a
utf8mb4/utf8_unicode_ci/utf8_0900_bin combination.

I have done some minimal testing, but nothing I can do would match a
conversion on a real live tracker.

So I am asking those of you with trackers running on MySQL to look at
the commit including documentation at:

  https://sourceforge.net/p/roundup/code/ci/8b31893f5930cbea37031d49bd08a631d1b6b654/

and test this. It will be part of the 2.4.0 release in July. I plan on
putting out a beta release (installable by pip) in mid May, but having
this tested before then would really help.

Thanks and have a great week.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.