Re: How to use uft8mb4?

[Mike Lischke]

Rama,

you have to separate data storage and visualization. Just because the values in your table aren't displayed properly doesn't mean they are completely wrong. Especially Unicode values beyond the Base Multilingual Pane (BMP, i.e. > 65535) might not be 100% supported in GUIs. That depends on used fonts and other factors. So, first try to find out what is actually stored in your table (e.g. by printing the values in hex) and if that shows the data is fine then focus on displaying them graphically.

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/