[mythtv] MythMusic

[Mark Edwards]

It appears that there is no Unicode support in mysql prior to v 4.1 -

extract from mysql doc...

Changes in release 4.1.x (Alpha)
================================

Version 4.1 of the MySQL server includes many enhancements and new
features: This version is available from our public bk tree and will be
available as a binary shortly

   * Subqueries:
          SELECT * from t1 where t1.a=(SELECT t2.b FROM t2);

          SELECT * from t1 where (1,2,3) in (SELECT a,b,c from t2);

   * Derived tables:
          SELECT t1.a from t1, (select * from t2) t3 WHERE t1.a=t3.a;

   * `INSERT ... ON DUPLICATE KEY UPDATE' syntax.  This allows you to
     `UPDATE' an existing row if existed from before. (`REPLACE' allows
     you to overwrite an existing row, which is a different thing).

   * Unicode (UTF8) support.

 etc...

regards,

Mark

----- Original Message -----
From: <rwk at americom.com>
To: <mythtv-dev at snowman.net>
Sent: Sunday, August 24, 2003 4:14 PM
Subject: [mythtv] MythMusic


> MythMusic fails to import any tracks which contain special characters.
> For example the first track from "Most Famous Opera Duets":
>
> Les Pêcheurs de perles, opera in 3 acts- Act I- Au Fond Du Temple
Saint.mp3
>
> The "ê" character seems to prevent the title from being imported into
> mysql.  There are 14 tracks on this album and only 7 are imported doing
> a "Scan Disk".  I.e., the music was ripped under Windows Media Player
> (by my wife), and then scanned into MythMusic.
>
> Exactly 7 of the titles on this album contain special characters like
> this and 7 do not.  From mysql:
>
> mysql> select tracknum, title from musicmetadata where album = 'The Most
Famous Opera Duets' order by tracknum;
>
+----------+----------------------------------------------------------------
-----------------------+
> | tracknum | title
|
>
+----------+----------------------------------------------------------------
-----------------------+
> |        2 | Madama Butterfly (Madame Butterfly), opera: Act I: Vogliatemi
Bene, Un Bene Piccolino |
> |        3 | Le nozze di Figaro (The Marriage of Figaro), opera, K. 492:
Act 3: Sull'aria          |
> |        4 | La Traviata, opera: Act I: Un Di, Felice, Eterea
|
> |        5 | Tristan und Isolde, opera, WWV 90: Act II: O Sink Hernieder,
Nacht Der Lieb           |
> |       10 | Der Rosenkavalier, opera, Op. 59: Act II: Mir Ist Die Ehre
Widerfahren                |
> |       13 | Lucia di Lammermoor, opera: Act I:  Ah! Verranna A Te
Sull'Aure                       |
> |       14 | Il Trovatore, opera: Act IV: Miserere...Quel Suon, Quelle
Preci                       |
>
+----------+----------------------------------------------------------------
-----------------------+
> 7 rows in set (0.00 sec)
>
> These are the exact titles which do not contain any special characters
> (i.e., characters > 128).  The rest simply have no record at all in the
> musicmetadata table.
>
> Can this be fixed?
>
> Please contact me if any additional information is needed.
>
> Thanks,
> Dick
>


----------------------------------------------------------------------------
----


_______________________________________________
mythtv-dev mailing list
mythtv-dev at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev