id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 3549 EIT doesn't handle á Á é É í Í ó Ó ú Ú ñ Ñ well. Spanish EPG josesuarez1983 Janne Grunau "Hello to everybody: I'm using 13559 svn rev, and Kubuntu 7.04. The system is set to use Spanish UTF-8 (defacto setting for Ubuntu with Spanish language). I've seen some people with problems on being able to get special characters on the program guide. I've tried applying some of the hints that were given, such as including the following in a .cnf file in the mysql config directory: [mysqld] character-set-server=latin1 [mysql.server] character-set-server=latin1 [mysqld_safe] character-set-server=latin1 [mysql] default-character-set=latin1 However, I can't get some of the special characters. I'm using the Spanish stations' EPG as the input for EIT. I don't know what charset the stations use here because I get a very strange thing: There are about 5 or 6 stations whose EPG is shown correctly on the Program Guide in MythTV, that is all the folowing characters are shown right: á Á é É í Í ó Ó ú Ú ñ Ñ However, all the other stations' EPGs aren't shown correctly. These are problems I found. The first part is what's contained in the mythconverg database, and the arrow shows what should be shown: DON QUIJOTE (1“ PARTE) --> DON QUIJOTE (1ª PARTE) BÆsico --> Básico FINAL CHAMPIONS: MILN - LIVERPOOL --> FINAL CHAMPIONS: MILÁN - LIVERPOOL ¿QuØ comemos hoy? --> ¿Qué comemos hoy? AL SALIR DE CLASE: 'Jugando con espŦritus' --> AL SALIR DE CLASE: 'Jugando con espíritus' AQU˝NO HAY QUIÉN VIVA --> AQUÍ NO HAY QUIÉN VIVA AL SALIR DE CLASE: 'Alguien matð a la estrella de la radio' --> AL SALIR DE CLASE: 'Alguien mató a la estrella de la radio' CLASIFICACI©N FORMULA 1: 'G.P. MONACO"" -> CLASIFICACIÓN FORMULA 1: 'G.P. MONACO"" Aæos luz --> Años luz CINE-MATRIX: SKY CAPTAIN Y EL MUNDO DEL MA¹ANA --> CINE-MATRIX: SKY CAPTAIN Y EL MUNDO DEL MAÑANA A la œltima --> A la última Well, the funny thing is that I have a Siemens Gigaset which uses vdr internally and that device can read all those special characters in all the stations' EPG, so I suppose there must be something wrong in how mythbackend stores the info. Finally, I'm attaching a file which contains the whole EIT table contained in the mythconverg database, so as to show what errors there are. If you guys need any additional info, please tell me. Thanks for the effort you are placing in the development of MythTV. It really is a terrific app!" patch closed minor 0.21 eit head medium fixed EIT, Special characters, Spanish Stations j.suarez.agapito@… 0