Subscribe to the
Percona Newsletter

Subscribe Now!
  Thursday, March 9, 2017    Sveta Smirnova

Please join Percona’s Principal Technical Services Engineer, Sveta Smirnova as she presents “Troubleshooting issues with MySQL Character Sets” on March 9, 2017 at 11:00 am PST / 2:00 pm EST (UTC-8).

Many MySQL novices find MySQL character set support puzzling. But after you understand how it is designed, you will find it much more powerful than many other competing database solutions.

MySQL allows to specify a character set for every object, and change it online. For years this has helped to create fast applications that can work with audiences all around the world. However, it also requires any DBA troubleshooting character set issues to have a deep understanding of how they work. Different sort rules and collations can complicate the process.

In the webinar we will discuss:

- Which character sets and collations MySQL supports
- How they can be set
- How to understand error messages
- How to solve character sets/collations compatibility issues
- What Server, application, command line and graphical tool options are available
- What to check first and how to continue troubleshooting
- What the various compatibility issues are
- How to convert data, created in earlier versions
- What the best practices are

About the Author

Sveta Smirnova

Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.