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 Jervin Real | Oct 16, 2013 | Insight for DBAs, MySQL
Here’s a problem some or most of us have encountered. You have a latin1 table defined like below, and your application is storing utf8 data to the column on a latin1 connection. Obviously, double encoding occurs. Now your development team decided to use utf8...