Re: Unable to query with Chinese character

[Peter Brawley]

In what ways does your setup differ from the following?

select version();
+-----------+
| version() |
+-----------+
| 8.0.22    |
+-----------+
show variables like 'char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8mb4                                                 |
| character_set_connection | utf8mb4                                                 |
| character_set_database   | utf8mb4                                                 |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8mb4                                                 |
| character_set_server     | utf8mb4                                                 |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+

drop table t;
create table t( s varchar(32) );
insert into t values('李');
select * from t where s like '李%';
+------+
| s    |
+------+
| 李   |
+------+