/etc/mysql/mariadb.conf.d/50-client.cnf :

[client]

# Default is Latin1, if you need UTF-8 set this (also in server section)

default-character-set = utf8mb4

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/

#include <iostream>

#include <mysql/mysql.h>

#include <stdexcept>

int main()

{

  MYSQL h;

  if (!mysql_init(&h)

    || mysql_options(&h, MYSQL_READ_DEFAULT_GROUP, "")

    // || mysql_options(&h, MYSQL_SET_CHARSET_NAME, "utf8mb4")

    || !mysql_real_connect(&h, "", "", NULL, "", 0, NULL, 0))

    throw std::runtime_error(mysql_error(&h));

  std::string q = "show variables like '%char%'";

  if (mysql_real_query(&h, q.data(), q.size()))

    throw std::runtime_error(mysql_error(&h));

  MYSQL_RES* result = mysql_store_result(&h);

  if (!result && mysql_errno(&h))

    throw std::runtime_error(mysql_error(&h));

  while (MYSQL_ROW row = mysql_fetch_row(result))

  {

    std::cout << row[0] << ": " << row[1] << "\n";

  }

  return 0;

}

Debian Release: 10.0

  APT prefers stable

  APT policy: (500, 'stable')

Architecture: amd64 (x86_64)

Kernel: Linux 4.19.0-5-amd64 (SMP w/2 CPU cores)

Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8)

Shell: /bin/sh linked to /usr/bin/dash

Init: systemd (via /run/systemd/system)

LSM: AppArmor: enabled

Versions of packages libmariadb-dev-compat depends on:

ii  libmariadb-dev  1:10.3.15-1

libmariadb-dev-compat recommends no packages.

libmariadb-dev-compat suggests no packages.

-- no debconf information