rbo > 26.01.2014, 07:04 PM
SQLite Datenbank schrieb:select Song.Name as Song_Name,Album.Name as Album_Name,Genre.Name as Genre_Name from Song left join Genre ON ( Genre.rowid = Song.GenreID ) left join Album ON ( Album.rowid = Song.AlbumID ) where Song.Name like 'Let There Be Rock';
Song_Name = Let There Be Rock
Album_Name = Let There Be Rock / AC/DC
Genre_Name = (79)
Song_Name = Let There Be Rock
Album_Name = Rough and Tough / AC/DC
Genre_Name = Hard Rock
MP3 Dateien schrieb:> [17:18:19]:27121 $ perl -MMP3::Info -MData:umper -E 'while(glob(q[*mp3])) { say "File: $_"; say Dumper get_mp3tag($_)}; '
File: [000001] Let There Be Rock.mp3
$VAR1 = {
'YEAR' => '2003',
'ARTIST' => "AC\x{ff0f}DC",
'COMMENT' => '',
'ALBUM' => "Let There Be Rock \x{ff0f} AC\x{ff0f}DC",
'TITLE' => 'Let There Be Rock',
'GENRE' => 'Hard Rock',
'TRACKNUM' => '3',
'TAGVERSION' => 'ID3v2.3.0'
};
File: [000002] Let There Be Rock.mp3
$VAR1 = {
'YEAR' => '2006',
'ARTIST' => "AC\x{ff0f}DC",
'COMMENT' => 'iTunNORM 00000857 00000660 00002445 000019AE 0001844E 0001844E 0000604D 000058DD 000444F0 00055621',
'TITLE' => 'Let There Be Rock',
'ALBUM' => "Rough and Tough \x{ff0f} AC\x{ff0f}DC",
'GENRE' => 'Hard Rock',
'TRACKNUM' => '17',
'TAGVERSION' => 'ID3v1.1 / ID3v2.3.0'
};
Uwe0110 > 26.01.2014, 09:48 PM
rbo > 26.01.2014, 10:16 PM
Administrator > 27.01.2014, 07:38 AM
rbo > 27.01.2014, 12:59 PM
Zitat: TCONQuelle: http://id3.org/d3v2.3.0
The 'Content type', which previously was stored as a one byte numeric
value only, is now a numeric string. You may use one or several of
the types as ID3v1.1 did or, since the category list would be
impossible to maintain with accurate and up to date categories,
define your own.
References to the ID3v1 genres can be made by, as first byte, enter
"(" followed by a number from the genres list (appendix A.) and
ended with a ")" character. This is optionally followed by a
refinement, e.g. "(21)" or "(4)Eurodisco". Several references can be
made in the same frame, e.g. "(51)(39)". If the refinement should
begin with a "(" character it should be replaced with "((", e.g. "((I
can figure out any genre)" or "(55)((I think...)". The following new
content types is defined in ID3v2 and is implemented in the same way
as the numerig content types, e.g. "(RX)".
RX Remix
CR Cover
Administrator > 28.01.2014, 07:48 AM
rbo > 09.02.2014, 02:50 PM
Administrator > 10.02.2014, 09:47 AM
rbo > 10.02.2014, 03:20 PM