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

emoji is not saving in utf8mb4_myanmar_ci

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.19
    • 10.0.20
    • Character Sets
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.