id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 4953,EIT Encoding on DVB-S Astra 19.2 wrong,camelreef,Janne Grunau,"Opening the ticket at Janne Grunau's request in this email: http://mythtv.org/pipermail/mythtv-users/2008-March/215249.html > I need the the results of following sql query: > > SELECT name, transportid, networkid, serviceid FROM channel as c, > dtv_multiplex as d WHERE c.mplexid = d.mplexid AND name IN (""first > broken channel"", ""second broken channel"", ...); [[BR]] {{{ mysql> SELECT name, transportid, networkid, serviceid FROM channel as c, dtv_multiplex as d WHERE c.mplexid = d.mplexid AND name IN (""NT1"", ""NRJ 12"",""DIRECT 8"", ""LCP"", ""EURONEWS"", ""CANAL+"", ""France 24 (en francais)""); +-------------------------+-------------+-----------+-----------+ | name | transportid | networkid | serviceid | +-------------------------+-------------+-----------+-----------+ | NT1 | 1094 | 1 | 17028 | | LCP | 1094 | 1 | 17027 | | CANAL+ | 1072 | 1 | 8201 | | EURONEWS | 1070 | 1 | 8004 | | EuroNews | 1091 | 1 | 31220 | | NRJ 12 | 1100 | 1 | 8710 | | DIRECT 8 | 1022 | 1 | 6911 | | DIRECT 8 | 1022 | 1 | 6901 | | France 24 (en Francais) | 1022 | 1 | 6905 | +-------------------------+-------------+-----------+-----------+ }}} All those above have broken accents. Here is a complete list of the DVB-S TV channels I have set on my system: {{{ mysql> SELECT name, transportid, networkid, serviceid FROM channel as c, dtv_multiplex as d WHERE c.mplexid = d.mplexid AND c.sourceid = ""3""; +-------------------------+-------------+-----------+-----------+ | name | transportid | networkid | serviceid | +-------------------------+-------------+-----------+-----------+ | LUXE.TV SD | 1108 | 1 | 3992 | | DIRECT 8 | 1022 | 1 | 6901 | | France 24 (en Francais) | 1022 | 1 | 6905 | | NRJ Hits | 1022 | 1 | 6908 | | DIRECT 8 | 1022 | 1 | 6911 | | EURONEWS | 1070 | 1 | 8004 | | CANAL+ | 1072 | 1 | 8201 | | NRJ 12 | 1100 | 1 | 8710 | | ARTE | 1024 | 1 | 9019 | | TV5MONDE EUROPE | 1026 | 1 | 10060 | | LCP | 1094 | 1 | 17027 | | NT1 | 1094 | 1 | 17028 | | arte | 1101 | 1 | 28109 | | EuroNews | 1091 | 1 | 31220 | +-------------------------+-------------+-----------+-----------+ }}} ",defect,closed,minor,0.21.1,eit,0.21-fixes,medium,fixed,EIT DVB-S accents encoding,,0