Differences

This shows you the differences between two versions of the page.

--- mysql:configure_utf8mb4 [2016/07/03 10:41] – peter
+++ mysql:configure_utf8mb4 [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 95: / Line 95: @@
+How does one find the offending index?  SHOW INDEXES FROM foo; will show all indexes on the table.  Combine that with DESCRIBE foo; and you can figure out which indexes are on columns longer than 191 characters.  With that out of the way, back to the action:
+<code mysql>
+mysql> DROP INDEX foo_1234 on foo;
+Query OK, 0 rows affected (0.00 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+mysql> ALTER TABLE foo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
+Query OK, 0 rows affected (0.11 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+CREATE INDEX foo_1234 ON foo (`baz`(191));
+</code>
 ===== Additional Notes and Considerations =====