Reply To: FirePlay Flash client for FireFly

#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