My issue is related to Debian Bookworm with 1:10.11.4-1~deb12u1, how did you get 1:10.11.5-3? ;-) Maybe regarding the client, this is related to $LANG or any other environment variable. But I faced trouble with a (local) server using for instance variables defined by a SET directive in a SELECT query. On the concerned system, the default is: /etc/default/locale:LANG=fr_FR.UTF-8
Le mer. 22 nov. 2023 à 17:23, Otto Kekäläinen <o...@debian.org> a écrit : > > Hi! > > I get 'latin1' when running the MariaDB client in a clean install: > > ``` > ± docker run -it -v ${PWD}:/build -w /build debian:sid bash > root@eb0c4013a610:/build# apt update > root@eb0c4013a610:/build# apt install -y mariadb-server > ... > Processing triggers for mariadb-server (1:10.11.5-3) ... > > root@eb0c4013a610:/build# /etc/init.d/mariadb start & > > root@eb0c4013a610:/build# mysql -e '\s' > -------------- > mysql Ver 15.1 Distrib 10.11.5-MariaDB, for debian-linux-gnu (x86_64) > using EditLine wrapper > > Connection id: 35 > Current database: > Current user: root@localhost > SSL: Not in use > Current pager: stdout > Using outfile: '' > Using delimiter: ; > Server: MariaDB > Server version: 10.11.5-MariaDB-3 Debian n/a > Protocol version: 10 > Connection: Localhost via UNIX socket > Server characterset: utf8mb4 > Db characterset: utf8mb4 > Client characterset: latin1 > Conn. characterset: latin1 > UNIX socket: /run/mysqld/mysqld.sock > Uptime: 37 sec > > Threads: 1 Questions: 66 Slow queries: 0 Opens: 33 Open tables: 26 > Queries per second avg: 1.783 > -------------- > > root@eb0c4013a610:/build# mariadb --help --verbose | grep character > character-sets-dir (No default value) > default-character-set auto > > > I am not sure where latin1 (or utfmb3 in your case) is inherited from. > > We could consider adding utfmb4 in > https://salsa.debian.org/mariadb-team/mariadb-server/-/blob/debian/latest/debian/additions/mariadb.conf.d/50-client.cnf > to ensure if is used by default by clients as well in Debian. > > We might also want to adopt > https://github.com/MariaDB/server/commit/0e8dfcfd421ebcb8dc13b4660cd3e6c6fbce2023 > in Debian already with 10.11 and not wait for 11.3.