This forum has been archived. All content is frozen. Please use KDE Discuss instead.

sToa = Stoa?

Tags: None
(comma "," separated)
User avatar
Dieter Schroeder
Registered Member
Posts
714
Karma
7
OS

sToa = Stoa?

Tue May 12, 2009 8:01 am
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.


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]