Opened 17 years ago
Closed 17 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';
(In [13782]) Fixes #3450
Convert recording title back to utf8 before storing it in the recordedprogram table.