[mythtv-users] EIT and special characters
Nicolas Will
nico at youplala.net
Fri Mar 14 10:41:53 UTC 2008
On Fri, 2008-03-14 at 01:11 +0100, Janne Grunau wrote:
> On Thursday 13 March 2008 18:09:16 Nicolas Will wrote:
> >
> > For the time being, I'm all EIT for my EPG.
> >
> > I have French channels from DVB-S.
> >
> > French is a language using accents and other nice things.
> >
> > In the on-screen guide and EPG, most French text is weird, as the
> > special accented characters are not displayed properly.
> >
> > Strangely, some channels do not display this problems, and accented
> > letters are very fine.
>
Hi Janne,
Funny how multiple mailing lists have the same subscribers ;o)
> The channels with the broken accents don't follow the dvb standard.
> They
> don't declare the encoding of the strings which means ISO6937 instead
> of the used ISO8859 variant. That's unfortunately a quite common
> failure and we can fix it.
Great!
>
> 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", ...);
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:
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 |
+-------------------------+-------------+-----------+-----------+
>
> If you see many channels with the same transportid and networkid
> please
> check if all channels with these values have broken accents.
yup, whole transports may be involved.
>
> Then open a ticket and attach the info from the query
I will
If I understand correctly, that will help fix mythTV's code.
Is there anything I can do on my system in the mean time?
Thanks very much for your help,
Nico
More information about the mythtv-users
mailing list