[#MDEV-16261] server collation in initial handshake packet doesn't change after changing character_set

After setting the global variable character_set_server to utf16, the server collation in initial handshake packet (sent from server to client) is sending old collation.

static int test_server_language(MYSQL *unused __attribute__((unused)))

  MYSQL *mysql= mysql_init(NULL);

  MYSQL_RES *res;

  MYSQL_ROW row;

  if (!mysql_real_connect(mysql, hostname, username, password, schema, port, socketname, 0))

    diag("Connection failed. Error: %s", mysql_error(mysql));

    mysql_close(mysql);

    return FAIL;

  mysql_query(mysql, "SET global character_set_server=utf16");

  mysql_query(mysql, "SELECT @@character_set_server");

  res= mysql_store_result(mysql);

  row= mysql_fetch_row(res);

  diag("character_set_server=%s", row[0]);

  diag("server collation in initial handshake packet=%d", mysql->server_language);

  mysql_free_result(res);

  mysql_close(mysql);

  diag("-- New connection --");

  mysql= mysql_init(NULL);

  if (!mysql_real_connect(mysql, hostname, username, password, schema, port, socketname, 0))

    diag("Connection failed. Error: %s", mysql_error(mysql));

    mysql_close(mysql);

    return FAIL;

  mysql_query(mysql, "SELECT @@character_set_server");

  res= mysql_store_result(mysql);

  row= mysql_fetch_row(res);

  diag("character_set_server=%s", row[0]);

  diag("server collation in initial handshake packet=%d", mysql->server_language);

  mysql_free_result(res);

  mysql_close(mysql);

  return OK;

[MDEV-16261] server collation in initial handshake packet doesn't change after changing character_set_server Created: 2018-05-23 Updated: 2023-04-27
Status:	Confirmed
Project:	MariaDB Server
Component/s:	Server
Affects Version/s:	5.5, 10.0, 10.1, 10.2, 10.3
Fix Version/s:	10.4

[MDEV-16261] server collation in initial handshake packet doesn't change after changing character_set_server Created: 2018-05-23 Updated: 2023-04-27