MySQL Workbench charset

mysql utf-8 character-encoding latin1 workbench
Math picture Math · Jul 28, 2011 · Viewed 85.6k times · Source

Does there exist any way to change the MySQL Workbench charset? My schema uses UTF-8 and when I view the table data (saved as UTF-8) or add data manually, it appears with charset errors, probably MySQL Workbench uses LATIN1.

Answer

sbrbot picture sbrbot · Sep 10, 2012

I think OP was asking about charset that Workbench uses in its editor and how to setup Workbench to use UTF-8 in GUI - not how to setup default charset used for database table in Workbench. At the moment in Workbench one can set database table charset but regardless of it Workbench will in it's GUI represent data using Latin1 charset!!! Also inserting data into UTF-8 tables through Workbench will result with wrong chars in database. I don't know either how to make Workbench deal with UTF-8 in its GUI.

Related questions

How to detect UTF-8 characters in a Latin1 encoded column - MySQL

I am about to undertake the tedious and gotcha-laden task of converting a database from Latin1 to UTF-8. At this point I simply want to check what sort of data I have stored in my tables, as that will determine …

Read More
mysqldump exporting data in a bad character set

Yesterday for the first time I exported my Mysql database and I found some very strange characters in the dump such as: INSERT INTO `piwik_archive_blob_2013_01` VALUES (15,'Actions_actions_url_6',1,'2013-01-17','2013-01-17',1,…

Read More
Why is my View utf8 and how can I change it to latin1

I'm having an issue where a client program needs to use a View, but it needs the results as latin1. Here's what I've got: mysql> show global variables like 'character_set%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | …

Read More