Bug #55770 utf8 doesn't support Unicode CJK EXT-B characters

• Submitted: 5 Aug 2010 9:08
• Modified: 7 Nov 2012 14:39
• Reporter: Chia-Pao Kuo
• Status: Not a Bug
• Category: MySQL Server: Charsets
• Severity: S2 (Serious)
• OS: Any
• CPU Architecture: Any

[5 Aug 2010 9:08] Chia-Pao Kuo

Description:
When a table or a field's encoding is set to utf8, it can not store Unicode CJK EXT-B characters such as 

How to repeat:
Use a table whose encoding is utf8.
Insert a ext-b character, such as

[5 Aug 2010 9:10] Chia-Pao Kuo

The bug reporting system can not display ext-b characters correctly, for instance

[5 Aug 2010 9:11] Chia-Pao Kuo

The bug reporting system can not display ext-b characters correctly, for instance U+2195C.
wtf

[5 Aug 2010 9:33] Sveta Smirnova

Thank you for the report.

This looks like not a bug unless you are using MySQL of version 5.5

Which version of MySQL do you use? Please read about UTF support at http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html also

[5 Sep 2010 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[7 Nov 2012 14:39] Alexander Barkov

"utf8" supports only Basic Multilingual Plane.
Please use "utf8mb4", it supports the full Unicode range.