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

Add support for utf8mb4_0900_* collations in MariaDB Server

Details

    Description

      Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
      This also makes migrations from MySQL 8.0 to MariaDB easier.
      This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0

      The plan is to implement most of the MySQL 8.0 utf8mb4_0900 collations as alias for the MariaDB utf8mb4_1400 collations.
      This should be fine in most cases as utf8mb4_1400 is a newer version of the utf8mb4_0900 collations.

      Attachments

        Issue Links

          causes

          Task - A task that needs to be done. MDEV-35876 speedup collation/charset lookup

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36213 Doubled memory usage (11.4.4 <-> 11.4.5)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Confirmed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35256 Alias MySQL 900 collations into MariaDB 1400 collations

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35642 Support replication from MySQL 8.0 to MariaDB

          • Major - Major loss of function.
          • Stalled

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25291 Add support for missing MySQL collations

          • Major - Major loss of function.
          • Needs Feedback

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36361 Wrong utf8mb4_0900_bin alias for utf8mb4_bin (should be utf8mb4_nopad_bin)

          • Major - Major loss of function.
          • Closed
          links to

          Web Link StackOverflow feature request for later collations than 520

          Activity

            Ascending order - Click to sort in descending order
            ivikga -- created issue -
            julien.fritsch Julien Fritsch made changes -
            Field Original Value New Value
            Fixing Priority 250
            danblack Daniel Black made changes -
            greenman Ian Gilfillan made changes -
            Labels collation utf8mb4 Compatibility collation utf8mb4
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 100647 ] MariaDB v4 [ 131178 ]
            greenman Ian Gilfillan made changes -
            Labels Compatibility collation utf8mb4 Compatibility collation compat80 utf8mb4
            monty Michael Widenius made changes -
            bar Alexander Barkov made changes -
            Fix Version/s N/A [ 14700 ]
            Assignee Alexander Barkov [ bar ]
            Resolution Won't Do [ 10201 ]
            Status Open [ 1 ] Closed [ 6 ]
            danblack Daniel Black made changes -
            monty Michael Widenius made changes -
            Resolution Won't Do [ 10201 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            monty Michael Widenius made changes -
            Assignee Alexander Barkov [ bar ] Michael Widenius [ monty ]
            monty Michael Widenius made changes -
            Fix Version/s 11.4.5 [ 29956 ]
            Fix Version/s N/A [ 14700 ]
            monty Michael Widenius made changes -
            Description Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data. Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
            This also makes migrations from MySQL 8.0 to MariaDB easier.
            This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0
            monty Michael Widenius made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            Description Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
            This also makes migrations from MySQL 8.0 to MariaDB easier.
            This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0             		Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
            This also makes migrations from MySQL 8.0 to MariaDB easier.
            This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0

            The plan is to implement most of the MySQL 8.0 character sets
            monty Michael Widenius made changes -
            Description Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
            This also makes migrations from MySQL 8.0 to MariaDB easier.
            This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0

            The plan is to implement most of the MySQL 8.0 character sets             		Please add support for utf8mb4_0900_* collations in MariaDB Server. This would allow for better accent handling in text data.
            This also makes migrations from MySQL 8.0 to MariaDB easier.
            This is also a requirement for getting replication to work from MySQL 8.0 to MariaDB and MariaDB to MySQL 8.0

            The plan is to implement most of the MySQL 8.0 utf8mb4_0900 collations as alias for the MariaDB utf8mb4_1400 collations.
            This should be fine in most cases as utf8mb4_1400 is a newer version of the utf8mb4_0900 collations.
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.4.5 [ 29956 ]
            monty Michael Widenius made changes -
            issue.field.resolutiondate 2024-12-30 14:33:50.0 2024-12-30 14:33:50.306
            monty Michael Widenius made changes -
            Fix Version/s 11.4.5 [ 29956 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            alice Alice Sherepa made changes -
            bar Alexander Barkov made changes -

            People

              monty Michael Widenius
              ivikga --
              Votes:
              12 Vote for this issue
              Watchers:
              9 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.