[debian-mysql] Bug#1055727: mariadb-client: inconsistent default charset between client and server

[Patrice Duroux]

Package: mariadb-client
Version: 1:10.11.4-1~deb12u1
Severity: wishlist

Dear Maintainer,

Could it be possible to provide a default charset value for both client
and server packages?

Currently I observe the following:

$ mysql -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 91009409
Server version: 10.11.4-MariaDB-1~deb12u1 Debian 12

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 [(none)]> \s
--------------
mysql  Ver 15.1 Distrib 10.11.4-MariaDB, for debian-linux-gnu (x86_64) using  EditLine wrapper

Connection id:		91009409
Current database:	
Current user:		patrice at localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server:			MariaDB
Server version:		10.11.4-MariaDB-1~deb12u1 Debian 12
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb3
Conn.  characterset:	utf8mb3

$ rgrep -B 3 "mb4" /etc/mysql/mariadb.conf.d/
/etc/mysql/mariadb.conf.d/50-server.cnf-
/etc/mysql/mariadb.conf.d/50-server.cnf-# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
/etc/mysql/mariadb.conf.d/50-server.cnf-# utf8 4-byte character set. See also client.cnf
/etc/mysql/mariadb.conf.d/50-server.cnf:character-set-server  = utf8mb4
/etc/mysql/mariadb.conf.d/50-server.cnf:collation-server      = utf8mb4_general_ci

and nothing in the 50-client.cnf


Regards,
Patrice

-- System Information:
Debian Release: 12.2
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.1.0-13-amd64 (SMP w/12 CPU threads; PREEMPT)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-client depends on:
ii  debianutils              5.7-0.5~deb12u1
ii  libc6                    2.36-9+deb12u3
ii  libconfig-inifiles-perl  3.000003-2
ii  libssl3                  3.0.11-1~deb12u2
ii  libstdc++6               12.2.0-14
ii  mariadb-client-core      1:10.11.4-1~deb12u1
ii  perl                     5.36.0-7
ii  zlib1g                   1:1.2.13.dfsg-1

Versions of packages mariadb-client recommends:
ii  libdbd-mysql-perl     4.050-5+b1
ii  libdbi-perl           1.643-4
ii  libterm-readkey-perl  2.38-2+b1

mariadb-client suggests no packages.

-- no debconf information