[mythtv] MythMusic

[rwk at americom.com]

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

I am not using Unicode filenames...  Just 8-bit ASCII, which I don't see
why mysql would pay any attention to.  It should just import all 8 bits
shouldn't it?

> 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
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>