mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "glance";
+----------------------------+
| default_character_set_name |
+----------------------------+
| latin1 |
+----------------------------+
1 row in set (0.00 sec)
mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "blah";
+----------------------------+
| default_character_set_name |
+----------------------------+
| utf8 |
+----------------------------+
1 row in set (0.00 sec)
mysql>
And as you can see creating a new db it is utf8 but the glance db/migrate_version table is created before the utf8 change takes effect. I attempted to move the order around but i cant see to figure out the correct incantation.
I linked the upstream fix because that seems like the correct way to get this resolved.
Yep, it seems that it's set up but it's not actually working. Here is a new build:
mysql> show variables like "%character%";show variables like "%collation%"; ------- ------- ------+ ------- ------- ------- ------- + ------- ------- ------+ ------- ------- ------- ------- + set_client | utf8 | set_connection | utf8 | set_database | latin1 | set_filesystem | binary | set_results | utf8 | set_server | utf8 | set_system | utf8 | mysql/charsets/ | ------- ------- ------+ ------- ------- ------- ------- +
+------
| Variable_name | Value |
+------
| character_
| character_
| character_
| character_
| character_
| character_
| character_
| character_sets_dir | /usr/share/
+------
8 rows in set (0.00 sec)
+------ ------- ------- --+---- ------- ------- -+ ------- ------- --+---- ------- ------- -+ connection | utf8_general_ci | ------- ------- --+---- ------- ------- -+
| Variable_name | Value |
+------
| collation_
| collation_database | latin1_swedish_ci |
| collation_server | utf8_general_ci |
+------
3 rows in set (0.00 sec)
mysql> create database blah;
Query OK, 1 row affected (0.00 sec)
mysql> SELECT default_ character_ set_name FROM information_ schema. SCHEMATA S WHERE schema_name = "glance"; ------- ------- ------- -+ character_ set_name | ------- ------- ------- -+ ------- ------- ------- -+
+------
| default_
+------
| latin1 |
+------
1 row in set (0.00 sec)
mysql> SELECT default_ character_ set_name FROM information_ schema. SCHEMATA S WHERE schema_name = "blah"; ------- ------- ------- -+ character_ set_name | ------- ------- ------- -+ ------- ------- ------- -+
+------
| default_
+------
| utf8 |
+------
1 row in set (0.00 sec)
mysql>
And as you can see creating a new db it is utf8 but the glance db/migrate_version table is created before the utf8 change takes effect. I attempted to move the order around but i cant see to figure out the correct incantation.
I linked the upstream fix because that seems like the correct way to get this resolved.