@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%';
Just on a sidenote, the SQL query isnt the same as the playlist.html query.
...where artist like 'Bj%';
really shows all songs by all artists that start with “Bj”. Results may not matter much, but a “like” certainly is less performant than an exact match.