Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8157

emoji is not saving in utf8mb4_myanmar_ci

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.0.19
    • Fix Version/s: 10.0.20
    • Component/s: Character Sets
    • Labels:
      None
    • Environment:
      Mac OS X 10.10

      Description

      I am using utf8mb4_myanmar_ci in table. It's working fine for Myanmar Unicode and can sort the correct order. However, it can store emoji text.

      mysql query is like

      INSERT INTO `myanmar`.`sort` (`id`, `my`) VALUES (NULL, 'ပြုံးမောင်မောင် ��');

      But it only store ပြုံးမောင်မောင် and not include emoji icon.

      SHOW TABLE STATUS is showing like that

        Attachments

          Activity

            People

            • Assignee:
              bar Alexander Barkov
              Reporter:
              saturngod Htain Lin Shwe
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: