[mythtv-users] myth and unicode..

Anduin Withers awithers at anduin.com
Sun May 11 21:52:23 UTC 2008

> Hmm. How come mythweb works ok?

It may do something wrong (at the minimum, at least in the sense that it
doesn't work like MythVideo). It also may work exactly how MythVideo can,
you just have different settings.

> Also the file appears in mythvideo just
> does not use the extra videometadata. Myth seems to have no problem with
> the filename and the way it is stored in the DB.

It depends on your settings, if you have it set to read from the file system
and match metadata the only link is the file name. If they do not match, and
you run the video manager, you should get a prompt to remove the entry from
the DB.

> A little confused as I
> don't know too much about locales and encoding etc..

More useful would be the hexadecimal representation for Déjà in the DB
(though unless you modified your paste it is wrong, you should see gibberish
for é and à if the column is using the "right" charset in .21).

If you were to "SELECT hex(filename) FROM videometadata WHERE filename LIKE
'% Vu %'" I bet you would see Déjà Vu as 44E96AE0205675, in UTF-8 it should
be 44C3A96AC3A0205675.

Anduin Withers 

More information about the mythtv-users mailing list