How to set UTF-8 encoding in MySQL?

To create a MySQL database which uses the UTF-8 character set:

1. Create a new database: create database <database_name> character set utf8mb4 collate utf8mb4_bin.
2. Open <TeamCity Data Directory> /config/database.properties and add the characterEncoding property: connectionProperties.characterEncoding=UTF-8.

How to set encoding to UTF-8 in SQL?

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; To exit the mysql program, type \q at the mysql> prompt. To verify that the character set encoding is now set to UTF-8, follow the steps in the Determining the current character encoding set procedure above.

How do I change MySQL column to UTF-8?

Resolution

1. Generate a file containing the ALTER TABLE queries. SELECT CONCAT('ALTER TABLE ', table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;') INTO OUTFILE '/tmp/alterstatements. …
2. Check if the output file is correct. cat /tmp/alterstatements.sql.
3. Run the SQL file against the current database.

Is MySQL UTF-8 or utf8mb4?

In MySQL, UTF8 can encode up to 3 bytes per character. The maximum character in Unicode however, requires 4 bytes to encode. As a result, UTF8 cannot fully support all Unicode characters. On the other hand, UTF8MB4 is an extension of UTF8 and uses a maximum of 4 bytes per character.

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE …
UTF-8 in MySQL can be tricky. Sometimes the problem isn’t noticed right away. Here is how I solved my recent encounter with UTF-8 issues and MySQL.
All new applications should use utf8mb4 . The utf8mb3 character set is deprecated. utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and MySQL 8.4.