by Roberto De Bem | Apr 16, 2024 | Insight for DBAs, MariaDB, MySQL
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out...
by Vadim Tkachenko | Sep 1, 2023 | Insight for DBAs, MySQL
This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most...
by Sveta Smirnova | Mar 29, 2022 | Insight for DBAs, Insight for Developers, MySQL
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. Migration to utf8mb4 has many advantages including: It can store more symbols, including emojis It has new collations for Asian...
by Vinicius Grippa | Aug 7, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might help. For example, in the case of a MySQL upgrade, it can be useful to have a master that is using a newer version of...
by Sveta Smirnova | Mar 28, 2017 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting Issues with MySQL Character Sets webinar. First, I want to thank everybody for attending the March 9 MySQL character sets troubleshooting webinar. The recording and slides for the webinar...
by Ryan Lowe | Oct 21, 2008 | Uncategorized
We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have...
