Your message dated Mon, 14 Apr 2025 08:00:00 +0300
with message-id
<caou6taatq55x4ulvvp_uqhe4riui_0eeqe-wrsiw1qatmje...@mail.gmail.com>
and subject line Re: Bug#1055727: mariadb-client: inconsistent default charset
between client and server
has caused the Debian Bug report #1055727,
regarding mariadb-client: inconsistent default charset between client and server
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1055727: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1055727
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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@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
--- End Message ---
--- Begin Message ---
Hi,
> If you read my previous message with some thought, you can see it has
> exact steps on how to start a fresh Docker container running Debian
> Sid and install MariaDB and test it.
>
> If you can reproduce the issue you reported in a fresh environment in
> a similar way it would prove the experience you had is not just
> because of some custom configuration in your specific environment.
>
> Thanks!
Since there was no follow-up, this bug can't be reproduced and I am
closing it as invalid.
I MariaDB 11.8 'utf8mb4' and 'uca1400_ai_ci' are now default both
upstream and in Debian, which should be the final solution for
character sets for now.
--- End Message ---
