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

Incorrect compare latin extended unicode symbol with charset utf8mb4

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.1.30
    • N/A
    • Character Sets
    • Linux centos 7 , windows 7

    Description

      Hello
      In the table, these words are the same AKKUŞSAN = AKKUSSAN

      CREATE TABLE t.table1 (
        t varchar(50) NOT NULL,
        UNIQUE INDEX UK_table1_t (t)
      )
      ENGINE = INNODB
      CHARACTER SET utf8mb4
      COLLATE utf8mb4_general_ci;
      

      execute

      INSERT INTO table1 (t) VALUES ('AKKUŞSAN');
      INSERT INTO table1 (t) VALUES ('AKKUSSAN');
      

      we get error
      Duplicate entry 'AKKUSSAN' for key 'UK_table1_t'

      But symbol S != Ş , it is different strings

      Attachments

        Activity

          workism@yandex.ru Stas created issue -
          workism@yandex.ru Stas made changes -
          Field Original Value New Value
          Summary Incorrect compare latin extended unicode symbol Incorrect compare latin extended unicode symbol with charset utf8mb4
          elenst Elena Stepanova made changes -
          Assignee Alexander Barkov [ bar ]
          bar Alexander Barkov made changes -
          issue.field.resolutiondate 2018-02-05 07:03:48.0 2018-02-05 07:03:48.627
          bar Alexander Barkov made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 85386 ] MariaDB v4 [ 153722 ]

          People

            bar Alexander Barkov
            workism@yandex.ru Stas
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.