New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] 4-byte UTF8 not supported when using MySQL database #7958

Closed
DanCech opened this Issue Mar 27, 2017 · 0 comments

Comments

Projects
None yet
3 participants
@DanCech
Member

DanCech commented Mar 27, 2017

Please include this information:

  • What Grafana version are you using? 4.2.0
  • What datasource are you using? Graphite
  • What OS are you running grafana on? Linux w/ MySQL
  • What did you do? Tried to save a dashboard containing a 4-byte character
  • What was the expected result? It should be saved correctly
  • What happened instead? I received the error "Dashboard not found"

The MySQL connection & database use the utf8 character set, which doesn't support 4-byte utf8 characters. To support these characters with MySQL Grafana needs to use the utf8mb4 character set for the database connection and table columns. The set of 4-byte utf8 characters includes all unicode characters from U+10000 to U+10FFFF, including the block for emoji.

To solve this problem will require updating the connection settings, and writing a migration script to update the table definitions.

@DanCech DanCech self-assigned this Mar 27, 2017

@DanCech DanCech changed the title from 4-byte UTF8 not supported when using MySQL database to [Bug] 4-byte UTF8 not supported when using MySQL database Mar 27, 2017

@torkelo torkelo added this to the 4.3.0 milestone Mar 28, 2017

@torkelo torkelo closed this Apr 10, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment