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

    XMLWordPrintable

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

            People

              Unassigned Unassigned
              mpflaum Maria M Pflaum
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.