MySQL query shows something like 0x8081 instead of special characters-CodePudding

When i run SELECT CHAR(128,129,130,131,132,133,134,135,136,137);

I got 0x80818283848586878889 istead of Çüéâäàåçêë.

Does anybody know why?

I'm using charset utf8mb4.

When I run show variables like '%char%'; I got

 -------------------------------------- -------------------------------- 
| 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                 | utf8mb3                        |
| character_sets_dir                   | /usr/share/mysql-8.0/charsets/ |
| validate_password.special_char_count | 1                              |
 -------------------------------------- --------------------------------

I'm using MySQL version 8.0.26

CodePudding user response：

The output charset is "DOS West European"

Use this query it will display the text in charset "DOS West European"

SELECT CHAR(128,129,130,131,132,133,134,135,136,137 using cp850)