is it possible to set character-set-server using these environment variables like?
export MB_DB_TYPE=mysql
export MB_DB_ENCODING=utf-8
for example in alfresco:
db.url=jdbc:mysql://localhost/alfresco52f?useUnicode=true&characterEncoding=utf-8&useSSL=false
Current situations:
Metabase version v0.28.5 without setting character-set-server=utf8 for [mysqld] in my.cnf,
the database is default to utf8.
create database metabase default character set utf8;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX,
DROP, CREATE TEMPORARY TABLES, LOCK TABLES
ON metabase.*
TO ‘metabase’@‘localhost’ IDENTIFIED BY ‘Xz=/9ieZ83’;
FLUSH PRIVILEGES;
mysql> show variables like ‘char%’;
±-------------------------±---------------------------+
| Variable_name | Value |
±-------------------------±---------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
±-------------------------±---------------------------+
8 rows in set (0.00 sec)
mysql> show variables like ‘collation%’;
±---------------------±------------------+
| Variable_name | Value |
±---------------------±------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | latin1_swedish_ci |
±---------------------±------------------+
3 rows in set (0.00 sec)
but the frontend see ?? after save to database;
after add character-set-server=utf8 to [mysqld] in my.cnf ,
this problem solved.