Re: Unable to query with Chinese character
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 |
+------+
| 李 |
+------+
Subject
Views
Written By
Posted
611
January 08, 2021 03:32AM
290
January 08, 2021 03:37AM
Re: Unable to query with Chinese character
313
January 08, 2021 09:17AM
245
July 05, 2021 02:25AM
318
July 05, 2021 01:11PM
Sorry, you can't reply to this topic. It has been closed.
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.