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 I’m using MySQL version 8.0.26 Answer The output charset is “DOS West European” Use this query it will display the text in charset “DOS West European”
Tag: character-encoding
SQL entries in French/English and Japanese
I have an old SQL4 database and I’m trying to re-upload it to our newly created database on Phpmyadmin. The characters in the tables are latin and japanese. I tried to change those specific columns but the result is still broken characters for the columns I need to display in Japanese. Here is a screenshot of my problem : https://imgur.com/a/P6GWrnF