[mythtv] Qt4 port: database character set change necessary

Janne Grunau janne-mythtv at grunau.be
Sat Mar 22 19:42:00 UTC 2008

On Saturday 22 March 2008 20:07:43 Andreas wrote:
> Am Samstag, 22. März 2008 11:00:37 schrieb Janne Grunau:
> > Hi,
> >
> > With qt4 our current way of storing raw UTF8 byte sequences in
> > latin1 encoded columns is not working anymore.
> >
> > The easiest way to get working utf8 strings is to change the
> > database character set to utf8. The alternatives we thought of have
> > bigger disadvantages than the 3 bytes per symbol utf8 in char()
> > columns and varchar() in keys and indices.
> [...]
> > I've prepared already the necessary db updates and once it is
> > committed to the branch no further db updates should be done in
> > trunk until the branch is merged to trunk.
> After my last move to a different backend machine I completely
> dropped the database and created a new one with utf-8 as it's
> character set. Would the db update you are planning 'screw up' my
> mythconverg as it already is utf-8, or can I just go with it?

You have to check it yourself but I think it shouldn't cause troubles as 
long as the data in the database is already utf8.

Make a backup and test it for yourself.


More information about the mythtv-dev mailing list