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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to