MariaDB [dac]> CREATE DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Query OK, 1 row affected (0.028 sec)

MariaDB [dac]> USE test;

Database changed

MariaDB [test]> DROP TABLE IF EXISTS collation_test;

Query OK, 0 rows affected, 1 warning (0.325 sec)

MariaDB [test]>

MariaDB [test]> CREATE TABLE collation_test (

    -> LETTERS TEXT NULL

    -> )

    -> ENGINE=ColumnStore;

Query OK, 0 rows affected (0.878 sec)

MariaDB [test]>

MariaDB [test]> INSERT INTO collation_test (LETTERS) VALUES ('a'), ('A'), ('b'), ('B');

Query OK, 4 rows affected (0.827 sec)

Records: 4  Duplicates: 0  Warnings: 0

MariaDB [test]>

MariaDB [test]> SELECT * FROM collation_test;

+---------+

| LETTERS |

+---------+

| a       |

| A       |

| b       |

| B       |

+---------+

4 rows in set (0.396 sec)

MariaDB [test]>

MariaDB [test]> SELECT * FROM collation_test WHERE LETTERS LIKE 'a';

+---------+

| LETTERS |

+---------+

| a       |

+---------+

1 row in set (0.029 sec)

MariaDB [test]> SELECT * FROM collation_test WHERE LETTERS IN ('a');

+---------+

| LETTERS |

+---------+

| a       |

| A       |

+---------+

2 rows in set (0.047 sec)

MariaDB [test]>

MariaDB [test]> SELECT * FROM collation_test WHERE LETTERS IN ('a' COLLATE utf8mb4_bin);

ERROR 1253 (42000): COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'latin1'