/opt3/dbs/mdb/10.2/bin/mysqld, Version: 10.2.5-MariaDB-log (MariaDB Server). started with:

Tcp port: 3309  Unix socket: /opt3/dbs/mdb/10.2/data/mysqld.sock

Time                 Id Command    Argument

170424 17:25:37     8 Connect   mdbuser@localhost as anonymous on test1

                    8 Query     SELECT @@version

                    8 Query     SET autocommit=1

                    8 Prepare   set character_set_client = 'utf8'

                    8 Execute   set character_set_client = 'utf8'

                    9 Connect   mdbuser@localhost as anonymous on test1

                    9 Query     SELECT @@version

                    9 Query     SET autocommit=1

                    9 Prepare   set character_set_client = 'utf8'

                    9 Execute   set character_set_client = 'utf8'

                    9 Close stmt

                    9 Prepare   DROP TABLE tutf8_é日

                    9 Execute   DROP TABLE tutf8_é日

                    9 Close stmt

                    9 Prepare   CREATE TABLE tutf8_é日 (pk integer NOT NULL PRIMARY KEY,c1_é日 char(10),vc1_é日 varchar(10))

                    9 Execute   CREATE TABLE tutf8_é日 (pk integer NOT NULL PRIMARY KEY,c1_é日 char(10),vc1_é日 varchar(10))

                    9 Close stmt

                    9 Prepare   insert into tutf8_é日 VALUES (?,?,?)

                    9 Execute   insert into tutf8_é日 VALUES (1,'1234567890','1234567890')

                    9 Close stmt

                    9 Prepare   insert into tutf8_é日 VALUES (?,?,?)

                    9 Execute   insert into tutf8_é日 VALUES (2,'አማር+','አማር+')

                    9 Close stmt

                    9 Prepare   insert into tutf8_é日 VALUES (?,?,?)

                    9 Execute   insert into tutf8_é日 VALUES (3,'âãäåçèéêëô','âãäåçèéêëô')

                    9 Close stmt

                    9 Prepare   insert into tutf8_é日 VALUES (?,?,?)

                    9 Execute   insert into tutf8_é日 VALUES (4,'日a本語bαδπአé','日a本語bαδπአé')

                    9 Close stmt

                    9 Prepare   update tutf8_é日 SET c1_é日 = 'አማር+',vc1_é日 = 'አማር+' WHERE pk = ?

                    9 Execute   update tutf8_é日 SET c1_é日 = 'አማር+',vc1_é日 = 'አማር+' WHERE pk = 2

                    9 Prepare   update tutf8_é日 SET c1_é日=?, vc1_é日=? WHERE pk = ?

                    9 Execute   update tutf8_é日 SET c1_é日='日a本語bαδπአé', vc1_é日='日a本語bαδπአé' WHERE pk = 4

                    9 Close stmt

                    9 Prepare   select tutf8_é日.* from   tutf8_é日 where pk = ?

                    9 Execute   select tutf8_é日.* from   tutf8_é日 where pk = 1

                    9 Close stmt

                    9 Prepare   select tutf8_é日.* from   tutf8_é日 where c1_é日 = ? AND vc1_é日 = ?

                    9 Execute   select tutf8_é日.* from   tutf8_é日 where c1_é日 = '1234567890' AND vc1_é日 = '1234567890'

                    9 Close stmt

                    9 Prepare   select tutf8_é日.* from   tutf8_é日 where pk = ?

                    9 Execute   select tutf8_é日.* from   tutf8_é日 where pk = 2

                    9 Close stmt

                    9 Close stmt

                    9 Quit

                    8 Close stmt

                    8 Quit

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.2.5-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [test1]> set character_set_client='utf8';

Query OK, 0 rows affected (0.00 sec)

MariaDB [test1]> show variables like "character_set_database";

+------------------------+-------+

| Variable_name          | Value |

+------------------------+-------+

| character_set_database | utf8  |

+------------------------+-------+

1 row in set (0.00 sec)

MariaDB [test1]> select * from tutf8_é日;

+----+----------------------+----------------------+

| pk | c1_é日               | vc1_é日              |

+----+----------------------+----------------------+

|  1 | 1234567890           | 1234567890           |

|  2 | ???+                 | ???+                 |

|  3 | âãäåçèéêëô           | âãäåçèéêëô           |

|  4 | ?a??b????é           | ?a??b????é           |

+----+----------------------+----------------------+

4 rows in set (0.00 sec)

MariaDB [test1]> SELECT CHARSET('a'), @@character_set_connection;

+--------------+----------------------------+

| CHARSET('a') | @@character_set_connection |

+--------------+----------------------------+

| utf8         | utf8                       |

+--------------+----------------------------+

1 row in set (0.00 sec)