Q. Prior to MySQL 6.0, utf8 was . . . . . . . .

  • (A) 3 bytes
  • (B) 4 bytes
  • (C) 8 bytes
  • (D) 9 bytes
πŸ’¬ Discuss
βœ… Correct Answer: (A) 3 bytes
Explanation: Prior to MySQL 6.0, the utf8 character encoding used by MySQL could store characters using up to 3 bytes per character. This allowed for a wide range of characters to be represented, but it had limitations, particularly for characters outside the Basic Multilingual Plane (BMP). MySQL 6.0 introduced utf8mb4 as a new character set that supports up to 4 bytes per character, enabling the storage of the full range of Unicode characters. Therefore, Option A is the correct answer.
Explanation by: Gopal Sharma
Prior to MySQL 6.0, the utf8 character encoding used by MySQL could store characters using up to 3 bytes per character. This allowed for a wide range of characters to be represented, but it had limitations, particularly for characters outside the Basic Multilingual Plane (BMP). MySQL 6.0 introduced utf8mb4 as a new character set that supports up to 4 bytes per character, enabling the storage of the full range of Unicode characters. Therefore, Option A is the correct answer.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
103
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Gopal Sharma
Publisher
πŸ“ˆ
88%
Success Rate