Comment 4 for bug 1356887

Revision history for this message
JJ Asghar (d-jj) wrote :

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%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| 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";
+----------------------------+
| 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.