FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FirePlay Flash client for FireFly › Reply To: FirePlay Flash client for FireFly
14/11/2007 at 11:02 PM
#13364
sonichouse
Participant
@Bo Mellberg wrote:
But it works in “playlist.html” so let’s look in the source for that?
o umlaut is hex C3B6 in the database so the query is ‘daap.songartist:Bj%C3%B6rk’
the SQL used was
bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> select distinct(hex(distinct(artist))) from songs where artist like 'Bj%';
426AC3B6726B
sqlite> .quit