[Buildbot-commits] [Buildbot] #2493: MySQL tables use default database character set

[Buildbot trac]

#2493: MySQL tables use default database character set
----------------------+-----------------------
Reporter:  andrewjcg  |      Owner:
    Type:  defect     |     Status:  new
Priority:  minor      |  Milestone:  undecided
 Version:  master     |   Keywords:  database
----------------------+-----------------------
 This is another one thats either low-pri or not really a buildbot bug:

 Even though buildbot requires utf8, tables created for a MySQL backed use
 the default character set used by the database they are created in, which
 causes issues when this is not utf8.  This is obviously a very minor issue
 since its easy to change the default character set or to fix the tables
 and this only has to be done once when the database tables are first
 created.  However, it'd probably be nice if buildbot would work
 independently of what the default database character set is.

 I'm not sure of a great solution here, but it will probably be similar to
 http://trac.buildbot.net/ticket/2492.  The SQAlchemy Table objects accept
 a 'mysql_charset' option which, when set to 'utf8', seems to fix the
 problem.  However, there are several places where Table objects are
 instantiated and its probably undesirable to change all these call sites.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2493>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation