[mythtv-users] problem with Greek characters in storage group paths

Yianni Vidalis yiannividalis at hotmail.com
Sat Jul 24 22:53:37 UTC 2010


Another update:

Viewing the lists, I read my post and realized that to properly read what I was explaining and what I was typing you must have the page encoding to utf8 (mine was accidentally at iso-8859-1 and the Greek word was exactly what mythtv was translating it to. So, I came to the conclusion that mythtv is not talking to mysql in utf8 but in iso-8859-1 or latin1 or something equivalent. 

Googling, I tried to ask mysql to always use utf8. I came across this post http://forums.mysql.com/read.php?103,281733,282260 and I added what the poster mentioned but it didn't help.

I wanted to see what was the behaviour of the debian system, so I truncated the videometadata and asked it to check for changes. It located all the old files without problem. AND, it also exhibits the conversion to latin1, which strangely it doesn't affect its search routine.

Yianni.



From: yiannividalis at hotmail.com
To: mythtv-users at mythtv.org
Date: Sat, 24 Jul 2010 19:02:47 +0300
Subject: Re: [mythtv-users] problem with Greek characters in storage group paths








I forgot to mention that I am running trunk, 

MythTV Version   : 25368M
MythTV Branch    : trunk
Network Protocol : 58
Library API      : 0.23.20100716-2
QT Version       : 4.6.3
Options compiled in:
 linux release using_alsa using_jack using_oss using_pulse using_pulseoutput using_backend using_dvb using_frontend using_hdpvr using_iptv using_ivtv using_libfftw3 using_lirc using_mheg using_opengl_video using_opengl_vsync using_qtdbus using_qtwebkit using_v4l using_x11 using_xrandr using_xv using_xvmc using_xvmc_vld using_xvmcw using_bindings_perl using_bindings_python using_opengl using_vdpau using_ffmpeg_threads using_live using_mheg



Yianni.



From: yiannividalis at hotmail.com
To: mythtv-users at mythtv.org
Date: Sat, 24 Jul 2010 18:59:45 +0300
Subject: [mythtv-users] problem with Greek characters in storage group paths








Hi.

I decided to change my old-ish debian lenny setup (my main backend + frontend) to openSuSE 11.2, so that it's consistent with the other computers at home. Boy, is this a bumpy ride!!

Luckily, I am using a separate HD, so the previous installation isn't destroyed and I can experiment with the new setup until I have perfected it.

The main problem I am facing now, is that I can't get the new backend to scan the storage group Videos for ... videos. It hangs at 0% for hours. "Top" shows high cpu usage for mysql and mythbackend, but no results.

The new setup is identical in nfs mounts, /myth location and LANG settings to the old debian one. Pointing the Videos storage group to a full-Ascii-path subfolder of the main folder succeeds in filling up with films. But when in mythtv-setup I point it directly to a Greek characters folder, upon pressing Enter I get a strange translation:
Instead of 
/myth/video/storage/Παιδικά/

I get 

/myth/video/storage/ αιδικά/

(I wish I could say it's Greek to me, but... I think it just looks Greek to you ;)

The entry stored in mythconverg is the correct one (I checked with phpmyadmin) but what I get on the screen is wrong. And mythtv-setup won't exit, complaining that the strange folder doesn't exist.

The output of the locale command is 
 
LANG=el_GR.UTF-8
LC_CTYPE="el_GR.UTF-8"
LC_NUMERIC="el_GR.UTF-8"
LC_TIME="el_GR.UTF-8"
LC_COLLATE="el_GR.UTF-8"
LC_MONETARY="el_GR.UTF-8"
LC_MESSAGES="el_GR.UTF-8"
LC_PAPER="el_GR.UTF-8"
LC_NAME="el_GR.UTF-8"
LC_ADDRESS="el_GR.UTF-8"
LC_TELEPHONE="el_GR.UTF-8"
LC_MEASUREMENT="el_GR.UTF-8"
LC_IDENTIFICATION="el_GR.UTF-8"
LC_ALL=

on all systems (debian lenny, opensuse 11.2 and another opensuse 11.2 which is the main storage server).

At this point I must mention that I tried just to import a mythconverg dump in the new system (even the host name is the same) but the mythbackend process kept dying on me a few seconds after it started). So I started with a blank db, etc.

Is this a misconfiguration on my part?

Can someone help me?

Thanks in advance,

Yianni
 		 	   		  
Hotmail: Δωρεάν, αξιόπιστη και αποτελεσματική υπηρεσία email. Αποκτήστε το τώρα. 		 	   		  
Hotmail: Αξιόπιστο email με την ισχυρή προστασία ενάντια στην ανεπιθύμητη αλληλογραφία που παρέχει η Microsoft. Εγγραφείτε τώρα. 		 	   		  
_________________________________________________________________
Hotmail: Δωρεάν, αξιόπιστη και αποτελεσματική υπηρεσία email.
https://signup.live.com/signup.aspx?id=60969
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100725/bf4491fb/attachment.htm>


More information about the mythtv-users mailing list