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

Cannot set character_set variables in my.ini

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Needs Feedback (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: N/A
    • Component/s: Variables
    • Labels:
      None

      Description

      According to the documentation, trying to set the variable character_set_results should done by something like:

      [mysqld]
      datadir=C:/Program Files/MariaDB 10.5/data
      port=3306
      default-storage-engine=MyISAM
      skip-innodb
      #innodb_buffer_pool_size=1010M
      character-set-results=utf8mb4
      [client]
      port=3306
      plugin-dir=C:/Program Files/MariaDB 10.5/lib/plugin
      

      But trying to start the server fails:

      C:\Program Files\MariaDB 10.5\bin>mariadbd --console
      2021-07-07 17:24:40 0 [Note] mariadbd (mysqld 10.5.9-MariaDB) starting as process 1664 ...
      2021-07-07 17:24:40 0 [Note] Plugin 'InnoDB' is disabled.
      2021-07-07 17:24:40 0 [Note] Plugin 'FEEDBACK' is disabled.
      2021-07-07 17:24:40 0 [Note] CONNECT: Version 1.07.0002 Feb 19 2021 10:36:16
      2021-07-07 17:24:40 0 [ERROR] mariadbd: unknown variable 'character-set-results=utf8mb4'
      2021-07-07 17:24:40 0 [ERROR] Aborting
      

      This happens with all character set variables. Other variables can be set without problems.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              bertrandop Olivier Bertrand
              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.