Skip to content
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

utf8mb4 support - german characters #8933

Closed
PRamia opened this issue Jan 7, 2020 · 1 comment
Closed

utf8mb4 support - german characters #8933

PRamia opened this issue Jan 7, 2020 · 1 comment
Labels

Comments

@PRamia
Copy link

@PRamia PRamia commented Jan 7, 2020

Environment

  • superset version: 0.34.0
  • python version: 3.6.9
  • Running Superset with Docker Containers

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

  • [ x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • [ x] I have checked the issue tracker for the same issue and I haven't found one similar.

PROBLEM:

I cannot render properly the german characters öäü. The data comes from an external MySQL server with utf8mb4 encoding + collation utf8mb4_unicode_520_ci

my superset_config.py contains:
SQLALCHEMY_DATABASE_URI = 'mysql://root:@db:3306/superset?charset=utf8mb4'

into the docker-compose.yml file added the following command under mysql:
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_520_ci

mysql> SHOW VARIABLES LIKE 'collation%';
+----------------------+------------------------+
| Variable_name | Value |
+----------------------+------------------------+
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_unicode_520_ci |
| collation_server | utf8mb4_unicode_520_ci |
+----------------------+------------------------+
3 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Maybe somebody faced this problem before and could help me.

Thanks a lot!

@issue-label-bot

This comment has been minimized.

Copy link

@issue-label-bot issue-label-bot bot commented Jan 7, 2020

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.59. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

@issue-label-bot issue-label-bot bot added the #bug label Jan 7, 2020
@PRamia PRamia closed this Jan 14, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.