Change MySQL default character set to UTF-8 in my.cnf?

by

To set the default to UTF-8, you want to add the following to my.cnf/my.ini

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4


[mysqld]
collation-server = utf8mb4_unicode_520_ci
init-connect="SET NAMES utf8mb4"
character-set-server = utf8mb4

If you want to change the character set for an existing DB, let me know… your question didn’t specify it directly so I am not sure if that’s what you want to do.

Edit: I replaced utf8 with utf8mb4 in the original answer due to utf8 only being a subset of UTF-8. MySQL and MariaDB both call UTF-8 utf8mb4.

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. How to convert an entire MySQL database characterset and collation to UTF-8?
  3. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  4. How can I find non-ASCII characters in MySQL?
  5. Save Data in Arabic in MySQL database
  6. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  7. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  8. Fetching UTF-8 text from MySQL in R returns “????”
  9. How to fix double-encoded UTF8 characters (in an utf-8 table)
  10. How to change the default charset of a MySQL table?
  11. MySQL distinction between e and é (e acute) – UNIQUE index
  12. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  13. Which DB technology is sued to solve the following search issue? [closed]
  14. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  15. How to escape apostrophe (‘) in MySql?
  16. How to join two tables mysql?
  17. SQL table with “list” entry vs SQL table with a row for each entry
  18. How do I restore a dump file from mysqldump?
  19. How to handle fragmentation of auto_increment ID column in MySQL
  20. MySQL – Conditional Foreign Key Constraints
  21. How to count items in comma separated list MySQL
  22. What effects does using a binary collation have?
  23. MySQL order by “best match”
  24. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  25. Using an IF Statement in a MySQL SELECT query
  26. Insert/ Update random date in MySQL
  27. How to determine which database is selected
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment