Default charset and collation for database

[mariadb]

Default charset and collation for database

[tianon]

This is possible today trivially with command-line flags, as noted/demonstrated in the image description: (https://github.com/docker-library/docs/blob/e72d96051254c263821f8fab32f05e0153221ed9/mariadb/README.md#configuration-without-a-cnf-file)

$ docker run ... mariadb --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

[tanji]

@visay You can use the command option to pass a command name and flag.
command: mysqld --flag --flag --flag

[visay]

@tianon how to integrate these command flags into the docker-compose.yml?

[visay]

Yes, that's one part for the charset but collation setting is still missing.

[yosifkit]

+1: docker-library/mysql#14 (comment)

[thaJeztah]

I think this is similar to the feature-request for MySQL; docker-library/mysql#14

[thaJeztah]

True! Just referring to that issue, so that (if possible), a single solution can be found for both MySQL and MariaDB 👍

[visay]

@tanji ah yes, working as expected. thanks a lot :)

[Alexhha]

Did I miss something but doesn't work for me

MariaDB [(none)]> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.001 sec)

mariadb:10.5

# docker inspect mariadb | jq .[].Config.Cmd
[
  "mysqld",
  "--character-set-server=utf8mb4",
  "--collation-server=utf8mb4_unicode_ci"
]

docker-compose.yml

version: '3'
services:
  mariadb:
    network_mode: host
    image: mariadb:10.5
    container_name: mariadb
    volumes:
      - /opt/docker/mariadb/db-data:/var/lib/mysql
    ports:
      - 3306:3306
    command: ['mysqld', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci']
    environment:
      - MARIADB_DATABASE=testdb
      - MARIADB_USER=user
      - MARIADB_PASSWORD=1234567
      - MARIADB_RANDOM_ROOT_PASSWORD=true

[grooverdan]

@Alexhha commenting on old closes issues tends to get missed. Please open a new issue next time.

What exactly doesn't work? character_set_server gained the value you set.

$ podman run -d --rm -e MARIADB_DATABASE=testdb -e  MARIADB_USER=user -e  MARIADB_PASSWORD=1234567 -e MARIADB_RANDOM_ROOT_PASSWORD=true --name mdb105-issue-16-test  mariadb:10.5 'mysqld' '--character-set-server=utf8mb4' '--collation-server=utf8mb4_unicode_ci'
3927be7d5acfb6a865fc86491e7a03fb135d17f812ca08111239262ef32ee71a

$ podman exec -ti mdb105-issue-16-test mysql -u user -p1234567 testdb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.11-MariaDB-1:10.5.11+maria~focal mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [testdb]> create table test (v varchar(300));
Query OK, 0 rows affected (0.012 sec)

MariaDB [testdb]> show create table test\G
*************************** 1. row ***************************
       Table: test
Create Table: CREATE TABLE `test` (
  `v` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
1 row in set (0.000 sec)

MariaDB [testdb]> show create database testdb\G
*************************** 1. row ***************************
       Database: testdb
Create Database: CREATE DATABASE `testdb` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */
1 row in set (0.000 sec)

The table and database are defined with your {character-set,collation}-server server directives.

Where you expecting other character set system variables to change? Character sets are documented on the knowledge base.