mythtv at cvs
Nov 10, 2009, 10:14 AM
Post #1 of 5
(815 views)
Permalink
|
|
Ticket #7535: mythrename uses wrong charset to update database. Files with some special chars not playable after that.
|
|
#7535: mythrename uses wrong charset to update database. Files with some special
chars not playable after that.
------------------------------------+---------------------------------------
Reporter: fgunni@… | Owner: ijr
Type: defect | Status: new
Priority: minor | Milestone: unknown
Component: MythTV - General | Version: 0.22
Severity: medium | Mlocked: 0
------------------------------------+---------------------------------------
If you have as example german umlauts (ä,ö,ü,ß) in shows, and use
mythrename, the filenames get updated, but in the database it seems
mythrename uses the wrong charset (looks to me, when using iso and
displaying utf or other way round)
So for "ä" there will be "ä" in the database as basename in table
recorded.
Updating the table for every wrong char with some sql like folowing works
around that for me:
UPDATE `recorded` SET basename=replace(basename,'ä','ä') WHERE
`basename` LIKE '%ä%'
UPDATE `recorded` SET basename=replace(basename,'ü','ü') WHERE
`basename` LIKE '%ü%'
UPDATE `recorded` SET basename=replace(basename,'ß','ß') WHERE
`basename` LIKE '%ß%'
UPDATE `recorded` SET basename=replace(basename,'ö','ö') WHERE
`basename` LIKE '%ö%'
Solution: Charset handling should be corrected in mythrename.pl Dont know
anything of perl, otherwise i would sure make a patch.
--
Ticket URL: <http://svn.mythtv.org/trac/ticket/7535>
MythTV <http://www.mythtv.org/>
MythTV
_______________________________________________
mythtv-commits mailing list
mythtv-commits [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-commits
|
