You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/01/07 16:00:56 UTC
[GitHub] [incubator-superset] PRamia opened a new issue #8933: utf8mb4
support - german characters
PRamia opened a new issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933
### 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!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #8933:
utf8mb4 support - german characters
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933#issuecomment-571649884
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.59. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] hossam-96 commented on issue #8933: utf8mb4
support - german characters
Posted by GitBox <gi...@apache.org>.
hossam-96 commented on issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933#issuecomment-584317215
Did you find a solution ?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] PRamia commented on issue #8933: utf8mb4
support - german characters
Posted by GitBox <gi...@apache.org>.
PRamia commented on issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933#issuecomment-584318585
yes, it was a problem from the source db
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] hossam-96 commented on issue #8933: utf8mb4
support - german characters
Posted by GitBox <gi...@apache.org>.
hossam-96 commented on issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933#issuecomment-584331750
> yes, it was a problem from the source db
okay thanks. the solution was actually to just add "?charset=utf8mb4" in the end of the SQLALCHEMY_DATABASE_URI
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] PRamia closed issue #8933: utf8mb4 support -
german characters
Posted by GitBox <gi...@apache.org>.
PRamia closed issue #8933: utf8mb4 support - german characters
URL: https://github.com/apache/incubator-superset/issues/8933
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org