[mythtv-users] EIT and special characters

[Nicolas Will]

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