How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?
Mysql – How to convert an entire MySQL database characterset and collation to UTF-8
character encodingMySQL
Related Topic
- Php – UTF-8 all the way through
- Python – How to connect to a MySQL Database in Python
- C# – How to get a consistent byte representation of strings in C# without manually specifying an encoding
- Mysql – How to get a list of user accounts using the command line in MySQL
- Mysql – Change MySQL default character set to UTF-8 in the.cnf
- Mysql – How to get the sizes of the tables of a MySQL database
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
Use the
ALTER DATABASE
andALTER TABLE
commands.Or if you're still on MySQL 5.5.2 or older which didn't support 4-byte UTF-8, use
utf8
instead ofutf8mb4
: