Re: Unable to query with Chinese character
Posted by: Peter Brawley
Date: January 08, 2021 09:17AM

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    |
+------+
| 李   |
+------+

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Unable to query with Chinese character
37
January 08, 2021 09:17AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.