Re: MySQL Character Sets

[Mike Lischke]

Tim Dilbert wrote:

> Thing that is a little weird is that I was looking
> at the charset for the mambo DB and Mamblefish and
> he had it set to "latin1". Werid... so yea... any
> idea? Should I set my DB charset to utf8?

Yes, definitely. You cannot store strings with characters that are not in the current charset. So the best way to handle that is to use Unicode (here in its special transformation format UTF-8) to store your strings. This way you don't need to care about what language the strings are in.

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/