29th / personnel-v3

Personnel management system version 3
https://www.29th.org
2 stars 6 forks source link

Upgrade database character set #295

Open wilson29thid opened 4 months ago

wilson29thid commented 4 months ago

MySQL moved from utf8mb3 to utf8mb4 a long time ago. Upgrading should be pretty seamless, but has the potential to cause data loss if we have any columns where their contents are close to the max size (I think we may, actually, e.g. abbrs). Here's an upgrade guide.

In terms of benefit, I'm not really sure what it is apart from upgrading from something that's quite old. Fililng under technical debt.