MySQL Forums
Forum List  »  Newbie

mysql console cant display UTF8
Posted by: David Ng
Date: July 14, 2020 06:59AM

the setting for the database is utf8mb4, the select statement shows UTF8 characters fine. But when writing UTF8 characters at mysql> console, it doesn't show


root@odroid:/opt/flask/code# echo "căn bản" (console OK with utf8)
căn bản

mysql> cn bn (when copy/paste ă and ả can't display)
->


mysql> select * from chiase where ID=1;
+----+----------------------+-----------------------------------------------------------------------------------------------------------+
| id | name | link |
+----+----------------------+-----------------------------------------------------------------------------------------------------------+
| 1 | Arduino căn bản. | <a href=https://drive.google.com/file/d/1tRXBQKCHIuspJbCd4GBDvds1thNLGTc2/view>Arduino căn bản.</a> |
+----+----------------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
mysql console cant display UTF8
July 14, 2020 06:59AM


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.