Registered Member
|
I decided to open a new topic for this.
Because of changing the structure of my music collection, I hadn't all artists handy on the initial scan, where "maudlin Of The Well" and "shEver" were added correct with leading lowercase letters. Tonight I've added "sToa", which now appears as "Stoa", although the tags show up as "sToa". Changing the artist's name from within amarok results in... no result, except of erasing the track summery, so I decided to take a look at the database. -----snip----- mysql> select name from artists where name="Stoa"; +------+ | name | +------+ | Stoa | +------+ 1 row in set (0.00 sec) mysql> update artists set name="sToa" where name="Stoa"; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select name from artists where name="Stoa"; +------+ | name | +------+ | sToa | +------+ 1 row in set (0.01 sec) -----snap----- As you can see after changing the name to "sToa" the query for "Stoa" still returns a result: "sToa"!? Seems, that the search is case-insensitive. Selecting "Shever" returns "shEver", too. Manually changing the name in the db results in Amarok showing "sToa". It's a SVN build (966704), so I won't report it as a bug. It's irritating, because the initial scan preserves the lowercase, but updating doesn't. I'll update to mysql 5.1.34, current is 5.1.30 and recompile amarok. Greetings m0nk
Last edited by Anonymous on Tue May 12, 2009 8:11 am, edited 1 time in total.
If men could get pregnant, abortion would be a sacrament.
|
Registered users: Bing [Bot], Google [Bot], Sogou [Bot]