search

wgu-opensource / osmt

OSMT is the Open Skills Management Tool
https://osmt.io
Other
44 stars 8 forks source link

Feature/utf8mb4 #434

Closed schagantiwgu closed 1 year ago

schagantiwgu commented 1 year ago

This is PR for converting existing my sql schema from using utf8mb3 to utf8mb4.

The following documents have been used as a reference along with official mysql documentation in this migration. https://www.percona.com/blog/migrating-to-utf8mb4-things-to-consider/ https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html

Hence the varchar columns have been adjusted to suit 4 byte unicode characters.

wgu-edwin commented 1 year ago

We should wait to merge the GH action runner fix to make sure tests pass before merging