# Convert all tables to UTF-8 with binary collation # and reset all char columns to correct width ALTER TABLE user MODIFY User char(32) NOT NULL default '', CONVERT TO CHARACTER SET utf8mb3 COLLATE utf8mb3_bin;