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

emoji is not saving in utf8mb4_myanmar_ci

    XMLWordPrintable

    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

        1. dbbug.png
          24 kB
          Htain Lin Shwe

          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: