Opened 13 years ago

Closed 12 years ago

#3450 closed defect (fixed)

If a title contains UTF-8 chars it wont get stored in "recordedprogramm" table

Reported by: anonymous Owned by: stuartm
Priority: minor Milestone: 0.21
Component: mythtv Version: head
Severity: medium Keywords: UTF-8
Cc: Ticket locked: no

Description

If you record a programme which contains UTF-8 characters it wont get stored in the recordedprogram table (it get stored correctly in the recorded table). I tracked it down to libs/libmythtv.cpp but dont know how to fix it. Here is a extract what mythbackend in debug mode is displaying: (see the Bold Characters, they should be the same on the "INSERT INTO recorded" and "REPLACE INTO recordedprogramm")

2007-05-11 23:26:15.982 MSqlQuery: INSERT INTO recorded (chanid, starttime, endtime, title, subtitle, description, hostname, category, recgroup, autoexpire, recordid, seriesid, programid, stars, previouslyshown, originalairdate, findid, transcoder, playgroup, recpriority, basename, progstart, progend, profile, duplicate) VALUES ('1002', '2007-05-11T23:26:00', '2007-05-11T23:30:00', 'Grünwald Freitagscomedy', 'BR Spät-Nachts-Show', 'D 2007 FSK 0M M Die Sommerpause der Grünwald Freitagscomedy wird eingeläutet. Erst am 14. September 2007 kommt die nächste Folge.

Günter Grünwald zieht deshalb umso mehr in dieser Sendung wieder alle Register. Witzig aufbereitetes Tagesgeschehen, spontane Einlagen und tolle Gäste s weitere Merkmale von Grünwald Freitagscomedy.

Diesmal zu Gast in der Grünwald Freitagscomedy: Axel Hacke.

Der Humorist Axel Hacke wird eine seiner lustigen Kurzgeschichten vorlesen und natürlich über Das Beste aus meinem Leben berichten - wie auch über dVerfilmung der SZ-Magazin-Serie im Ersten.

Monika Gruber - bei Grünwald Freitagscomedy für den Bereich Klatsch & Tratsch zuständig - ist natürlich wieder mit jeder Menge Society-Neuigkeiten von der Partie.', 'myserver', 'Comedy', 'Default', 0, 1571, '262790105', ,0, 0, '2007-05-11', 0, 0, 'Default', 0, '1002_20070511232600.mpg', '2007-05-11T22:30:00', '2007-05-11T23:30:00', 'Default', 0)
2007-05-11 23:26:15.982 MSqlQuery: UNLOCK TABLES
2007-05-11 23:26:15.983 MSqlQuery: UPDATE record SET last_record = NOW() WHERE recordid = 1571
2007-05-11 23:26:16.002 MSqlQuery: DELETE FROM recordedseek WHERE chanid = '1002' AND starttime = '2007-05-11T23:26:00';
2007-05-11 23:26:16.003 MSqlQuery: DELETE FROM recordedmarkup WHERE chanid = '1002' AND starttime = '2007-05-11T23:26:00';
2007-05-11 23:26:16.029 MSqlQuery: REPLACE INTO recordedcredits SELECT * FROM credits WHERE chanid = '1002' AND starttime = '2007-05-11T22:30:00';
2007-05-11 23:26:16.030 MSqlQuery: REPLACE INTO recordedprogram SELECT * from program WHERE chanid = '1002' AND starttime = '2007-05-11T22:30:00' AND title = 'Grünwald Freitagscomedy';

Attachments (1)

myth.log (2.3 KB) - added by anonymous 13 years ago.

Download all attachments as: .zip

Change History (3)

Changed 13 years ago by anonymous

Attachment: myth.log added

comment:1 Changed 13 years ago by stuartm

Milestone: unknown0.21
Owner: changed from Isaac Richards to stuartm

comment:2 Changed 12 years ago by stuartm

Resolution: fixed
Status: newclosed

(In [13782]) Fixes #3450

Convert recording title back to utf8 before storing it in the recordedprogram table.

Note: See TracTickets for help on using tickets.