MariaDB [test]> set names utf8;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'фи';

+------+

| фи   |

+------+

| фи   |

+------+

1 row in set (0.00 sec)

MariaDB [test]> set statement character_set_client = latin5 for select 'фи';

+------+

| фи   |

+------+

| фи   |

+------+

1 row in set (0.00 sec)

MariaDB [test]> set character_set_client = latin5;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'фи';

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

| фи     |

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

| фи     |

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

1 row in set (0.00 sec)

MariaDB [test]> set names utf8;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'фи';

+------+

| фи   |

+------+

| фи   |

+------+

1 row in set (0.00 sec)

MariaDB [test]> set statement CHARACTER_SET_CONNECTION = latin5 for select 'фи';

+------+

| фи   |

+------+

| фи   |

+------+

1 row in set (0.01 sec)

MariaDB [test]> set character_set_connection = latin5;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'фи';

+----+

| ?? |

+----+

| ?? |

+----+

1 row in set (0.00 sec)

MariaDB [test]> set names utf8;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> system touch 'файл';

MariaDB [test]> create table tmp (i int);

Query OK, 0 rows affected (0.56 sec)

MariaDB [test]> set statement CHARACTER_SET_FILESYSTEM = latin5 for load data local infile 'файл' into table tmp;

Query OK, 0 rows affected (0.00 sec)                 

Records: 0  Deleted: 0  Skipped: 0  Warnings: 0

MariaDB [test]> set character_set_filesystem = latin5;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> load data local infile 'файл' into table tmp;

ERROR 2 (HY000): File '????' not found (Errcode: 2)ne

MariaDB [test]> set names utf8;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> set statement collation_connection = utf8_bin for select 'a' union select 'b' union select 'A' order by 1;

+---+

| a |

+---+

| a |

| b |

+---+

2 rows in set (0.00 sec)

MariaDB [test]> set collation_connection = utf8_bin;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 'a' union select 'b' union select 'A' order by 1;

+---+

| a |

+---+

| A |

| a |

| b |

+---+

3 rows in set (0.00 sec)