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

Incorrect lowercasing of word-final Greek capital Sigma (Σ)

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.7.2
    • 11.4
    • Character Sets, Parser
    • None
    • win11 with docker

    Description

      When applying UPPER() to the Greek word 'κόσμος', MariaDB returns 'ΚΌΣΜΟΣ'. However, applying LOWER() to that result returns 'κόσμοσ' instead of the original 'κόσμος'.

      According to wikipedia (https://en.wikipedia.org/wiki/Sigma), there are two forms of lowercase for Greek capital Sigma (Σ):

      • If Σ is at the end of a word, it should lowercase to ς
      • If Σ is in the middle of a word, it should lowercase to σ

      How to Repeat:

      ```sql
      SELECT LOWER(UPPER('κόσμος'));
      ```

      Attachments

        Activity

          People

            bar Alexander Barkov
            Phasheng Bosheng Peng
            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.