Prior to MySQL 6.0, the utf8 character set in MySQL was capable of storing up to 3 bytes per character. This was an implementation of UTF-8 encoding, but it had a limitation: it could only handle characters that fit within the Basic Multilingual Plane (BMP) of Unicode, which includes most characters, but not all.
In this earlier version of utf8, some characters (like certain emoji or less common scripts) could not be represented because they required more than 3 bytes. This limitation was addressed with the introduction of the utf8mb4 character set, which supports up to 4 bytes per character and allows the full range of Unicode characters.
Therefore, prior to MySQL 6.0, the utf8 character set used 3 bytes per character.
You must be Logged in to update hint/solution
Be the first to start discuss.
Q. Slow shutdown can be performed by setting innodb_fast_shutdown to _____________.
Q. REGEXP does not take collation into account.
Q. What is the full form of GUID?
Q. What is meant by Partial Database Control?
Q. The recovery of data changes made since a given point in time is called . . . . . . . .
Q. What is the maximum length for alias names in terms of characters?
Q. Is it important to provide where condition with update statement in MYSQL?
Q. Which statement is used to force the optimizer to use tables in a particular order?
Discusssion
Login to discuss.