Re: problem with Workbench / UTF-8

[Mike Lischke]

Hey Luc,

MySQL Workbench internally uses Unicode (mostly in UTF-8 encoding). So, if you enter your data and get it back correctly you can be sure this part is working fine. Check also that the table you are inserting the text uses a Unicode encoding too (at least the columns you have trouble with, better set it for the entire table if that is not the case yet).

If the display in your webpage is wrong you should now check how you get the data. If you get 2 or more weird characters for a single french character then you are probably not reading the data as UTF-8 (provided you use UTF-8 as encoding). UTF-8 uses a lead byte plus 1 or more trail bytes to encode a single character. If you however get an empty box or no output for a single char (but still only one char wide) then most likely you have a wrong font. However on modern OSes with virtually any web browser you should not have to worry about that (maybe if you have Klingon text that's different ...).

Mike

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/