Provide config option to specify database encoding

Bug #965094 reported by Robert Ayres
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql (Juju Charms Collection)
Confirmed
Medium
Unassigned

Bug Description

Default database encoding is set to 'utf8'. This causes problems with the Hive charm that needs to use 'latin1'. In particular, utf8 encoding uses 3 bytes per character which exceeds the maximum column/row length when used with the Hive MySQL schema.

I think it'd be great if you could use a config option to specify this, where blank would simply default to MySQL's default.

Related branches

Changed in mysql (Juju Charms Collection):
status: New → Confirmed
importance: Undecided → Medium
Revision history for this message
Jay R. Wren (evarlast) wrote :

IMO it would be better to implement an interface on the mysql relation for the database encoding, which is not required and defaults to utf8 and update the hive charm to set the encoding to latin1.

Revision history for this message
Jay R. Wren (evarlast) wrote :

https://code.launchpad.net/~evarlast/charms/precise/hive/encoding/+merge/226540
and
https://code.launchpad.net/~evarlast/charms/precise/mysql/encoding/+merge/226538

implement a fix in both charms.

In the future, if other charms need to use a different mysql database encoding, they can specify it the same way.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.