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

CLI client for 10.5 does not recognize utf8mb3 but server does

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5
    • 10.4, 10.5
    • None
    • CentOS Linux release 7.9.2009 (Core) in AWS VM

    Description

      Setting the below works as expected for 10.6 (despite being 10.5) and enables forward-looking customers to prepare their configuration files for a future 10.6+ upgrade-

      [server]
      character_set_server=utf8mb3

      At runtime, the server detects-

      SELECT @@character_set_server, @@collation_server;
      +------------------------+--------------------+
      | @@character_set_server | @@collation_server |
      +------------------------+--------------------+
      | utf8                   | utf8_general_ci    |
      +------------------------+--------------------+

      However, when configuring the MariaDB CLI client like-

      [client]
      default_character_set=utf8mb3

      The below error occurs when invoking mariadb-

      ERROR 2019 (00000): Can't initialize character set utf8mb3 (path: compiled_in)

      Note this also occurs for-

      mariadb --default-character-set='utf8mb3'

      Please note these CLI configurations work fine in Server 10.6.5.

      Would it be possible to backport enablement of this from 10.6 to 10.5 (and any other versions for which character_set_server=utf8mb3 is valid syntax?

      This is particularly important for MariaDB client configurations. While server configurations tend to be centralized to the MariaDB backend servers and managed by dedicated teams, client configurations and runtime parameters tend to be much more decentralized, and it can take significant time for client organizations to wrangle these into spec. By enabling 10.6+ syntax for client configurations in versions prior to 10.6, customers can start this process now, making them better prepared to move to 10.6, and even better prepared to handle what occurs when we inevitably change the default character set defined by utf8 from utf8mb3 to utf8mb4.

      Attachments

        Activity

          People

            rucha174 Rucha Deodhar
            rob.schwyzer@mariadb.com Rob Schwyzer
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.