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

Adding case sensitive utf8 collation to MariaDB

Details

    Description

      Hello,
      I would like to ask you to add a case sensitive utf8 collation, e.g. utf8_general_cs or something like that. Please, let me know how long will it take to implement this extension.
      Thanks!
      P.S. In process of migration from Oracle DBMS to MariaDB, we found out that MariaDB is lacking unicode case sensitive collations.

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-27009 Add UCA-14.0.0 collations

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

          Activity

            Ascending order - Click to sort in descending order
            jdavie02 Jonathan Davies added a comment -

            It appears that this is being addressed in MySQL - see here. Is there an update on when this may be addressed in MariaDB?

            jdavie02 Jonathan Davies added a comment - It appears that this is being addressed in MySQL - see here . Is there an update on when this may be addressed in MariaDB?
            onyxfire Lance Fogle added a comment -

            Since this is already resolved after MySQL 8.0.1, this should not be that hard to port into MariaDB I wouldn't think. This is several years old and still hasn't been done though MariaDB is supposed to be a "drop-in replacement for MySQL" and this would be a very key feature in modern databases.

            Is there any plan on the roadmap at all to bring this in from MySQL codebase?

            onyxfire Lance Fogle added a comment - Since this is already resolved after MySQL 8.0.1, this should not be that hard to port into MariaDB I wouldn't think. This is several years old and still hasn't been done though MariaDB is supposed to be a "drop-in replacement for MySQL" and this would be a very key feature in modern databases. Is there any plan on the roadmap at all to bring this in from MySQL codebase?
            bar Alexander Barkov added a comment - - edited

            Case sensitive collations were added to MariaDB-10.10 under terms of MDEV-27009.

            bar Alexander Barkov added a comment - - edited Case sensitive collations were added to MariaDB-10.10 under terms of MDEV-27009 .

            People

              bar Alexander Barkov
              romanshkola Roman Shkola
              Votes:
              6 Vote for this issue
              Watchers:
              11 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.