By default, the character set is now utf8. mysql > UNINSTALL PLUGIN validate_password; Query OK, 0 rows affected, 1 warning (0.01 sec). Software Engineering Stack Exchange is a question and answer site for professionals, academics, and students working within the systems development life cycle. Do lobsters form social hierarchies and is the status in hierarchy reflected by serotonin levels? You'll need to shorten the column length of some character columns or shorten the length of the index on the columns using this syntax to ensure that it is shorter than the limit. A couple of days ago I was notified by a visitor of one of my websites that searching for a term with a non-ASCII character in it (in this case, Mnchhausen) was returning over 500 results, though none of the results actually matched the given search term. The real issue is, "Is it a technical issue we are dealing with?" Webjava,mysql,UTF8UTF-8ideaUTF-8JAVAutf-8web.xmlutf-8