Convert charset to utf8mb4 for mysql

ubc / compair

ComPAIR: a peer review application pairing student answers for deeper learning through comparison of peer work

http://ubc.github.io/compair

GNU General Public License v3.0

36 stars 11 forks source link

Closed kitsook closed 4 years ago

kitsook commented 4 years ago

change from charset utf8 to utf8mb4. utf8 can only store char up to 3-byte long. many emoji characters / symbols can't be stored
resize indexed char/varchar columns to not longer than 191. mysql has limits on index size

Closes #908