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)
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.