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

Would like sort order for sql_mode=ORACLE to match Oracle sort order

Details

    Description

      MariaDB in oracle-mode orders alpha-numeric as follows:

      In mariaDB

      AA1
      		 
      AAA
      		 
      BBB

      But In oracle:

      AAA
      		 
      AA1
      		 
      BBB

      Can we get MariaDB to act like Oracle when sorting in SQL_MODE=ORACLE?

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-23400 Add UCA case sensitive accent sensitive collations for Unicode character sets

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov added a comment -

            This is a different behaviour, not a bug.

            Oracle compatible sort orders can be implemented via new MariaDB collations. That's relatively easy to do.

            bar Alexander Barkov added a comment - This is a different behaviour, not a bug. Oracle compatible sort orders can be implemented via new MariaDB collations. That's relatively easy to do.
            karlsson Anders Karlsson added a comment -

            Testing in Oracle using the AL32UTF8 character set, which is standard UTF8, the behavior is the same in MariaDB and Oracle. The other common Oracle character set is WE8DEC (in older versions or Oracle) / WE8ISO8859P1 (in more recent versions) hasn't been tested.

            karlsson Anders Karlsson added a comment - Testing in Oracle using the AL32UTF8 character set, which is standard UTF8, the behavior is the same in MariaDB and Oracle. The other common Oracle character set is WE8DEC (in older versions or Oracle) / WE8ISO8859P1 (in more recent versions) hasn't been tested.

            People

              Unassigned Unassigned
              mpflaum Maria M Pflaum (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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