Converting the webwork database from the latin1 to the utf8mb4 character set
Jump to navigation
Jump to search
These instructions explain how to convert the webwork database from the latin1 to the utf8mb4 character set.
Check What the Current Character Set Is
Before we begin let's make use sure the webwork database is using the latin1 character set.
Log into mysql. Depending on your OS and mysql version, you will either use the command
$ mysql -u root -p Enter Password: <mysql root password>
or
$ sudo mysql [sudo] password for wwadmin: <wwadmin password>
You should see something very similar to
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 ... Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.