[mythtv-users] myth and unicode..

[Damian O'Sullivan]

On Sun, 11 May 2008, Anduin Withers wrote:
> It may do something wrong (at the minimum, at least in the sense that it
> doesn't work like MythVideo). It also may work exactly how MythVideo can,
> you just have different settings.

How do you mean by differnet settings?

> It depends on your settings, if you have it set to read from the file system
> and match metadata the only link is the file name. If they do not match, and
> you run the video manager, you should get a prompt to remove the entry from
> the DB.

I delete the line in mysql and then run an import.

> More useful would be the hexadecimal representation for Déjà in the DB
> (though unless you modified your paste it is wrong, you should see gibberish
> for é and à if the column is using the "right" charset in .21).
>
> If you were to "SELECT hex(filename) FROM videometadata WHERE filename LIKE
> '% Vu %'" I bet you would see Déjà Vu as 44E96AE0205675, in UTF-8 it should
> be 44C3A96AC3A0205675.

  SELECT hex(filename) FROM videometadata WHERE filename LIKE '% Vu %';
+----------------------------------------------------------------------------------------------------------------------------------+
| hex(filename) 
|
+----------------------------------------------------------------------------------------------------------------------------------+
| 
2F54565365726965732F536861726B2F536561736F6E20312F31783037202D2044C383C2A96AC383C2A020567520416C6C204F76657220416761696E2E617669 
|
+----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

I can't see either. I am just looking for a way that when I run my perl 
import script that does a tv.com lookup that I can import the data into 
mysql right. So should I assume that I just enter the data into the DB 
without encoding it or should I encode it? For prosperity this is what ls 
-b looks like :

damian at mythtv-box:~/SVN/trunk/mythtv$ ls -b /TVSeries/Shark/Season\ 
1/1x07\ -\ Déjà\ Vu\ All\ Over\ Again.avi
/TVSeries/Shark/Season\ 1/1x07\ -\ Déjà\ Vu\ All\ Over\ Again.avi
This is utf8 encoded.

damian at mythtv-box:~/SVN/trunk/mythtv$ echo $LANG
en_IE.UTF-8


Thanks,

D.