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

Incorrect compare latin extended unicode symbol with charset utf8mb4

    XMLWordPrintable

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

          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.