Ticket #7535 (closed defect: wontfix)
Opened 4 years ago
Last modified 3 years ago
mythrename uses wrong charset to update database. Files with some special chars not playable after that.
|Reported by:||fgunni@…||Owned by:||mdean|
|Component:||MythTV - General||Version:||0.22|
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.
comment:1 Changed 4 years ago by anonymous
comment:2 Changed 3 years ago by mdean
- Owner changed from ijr to mdean
- Status changed from new to accepted
comment:3 Changed 3 years ago by mdean
comment:4 Changed 3 years ago by mdean
- Status changed from accepted to closed
- Resolution set to wontfix
- Milestone changed from unknown to 0.23