Question

How to convert an MySQL database characterset and collation to UTF-8?

Answer 1

To convert the character encoding set to UTF-8: Log in to your A2 Hosting SSH account. When the edits are complete, press Ctrl+X, type y to save the file, and then press ENTER. To change the character set encoding to UTF-8 for the database itself, type the following command at the mysql> prompt.