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

Collation error utf8mb4_uca1400_ai_ci

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 11.4.4
    • N/A
    • Character Sets
    • MariaDB 11.4.4-MariaDB-ubu2204
      cPanel Version 124.0.21
      Ubuntu v22.04.0 STANDARD kvm

    Description

      The web application works without error with MySQL8,
      The problem is only with MariaDB 11.4 (cPanel)

      The database is using utf8mb4_general_ci as default and still having the error

      "Información
      SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci, COERCIBLE) and (utf8mb4_uca1400_ai_ci,COERCIBLE) for operation'='"
      (collation_error_1.jp)

      Attachments

        1. maybe-similiar-issue.jpg
          maybe-similiar-issue.jpg
          161 kB
        2. error3.png
          error3.png
          63 kB
        3. error2.png
          error2.png
          237 kB
        4. collation_error_1.jpg
          collation_error_1.jpg
          29 kB

        Issue Links

          links to

          Web Link matomo GH issue 22536

          Activity

            People

              Unassigned Unassigned
              arielr Ariel R.
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.