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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 20m
                20m

                Git Integration

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