diff options
| -rw-r--r-- | issues/systems/mariadb/move-to-innodb.gmi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index 05e4b90..c6b52c7 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -691,8 +691,8 @@ MariaDB [db_webqtl]> SHOW CHARACTER SET LIKE 'utf8mb4'; To properly convert a table with broken characters, first convet the table to BINARY format and thereafter convert to utf8mb1. Here's an example of doing that with the Investigators table: ``` -ALTER TABLE InvestigatorsBackUp CONVERT TO CHARACTER SET BINARY; -ALTER TABLE InvestigatorsBackUp CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; +ALTER TABLE Investigators CONVERT TO CHARACTER SET BINARY; +ALTER TABLE Investigators CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; ``` You can read more here: |