1280 Diacritical in search string

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: 1280 Diacritical in search string

Re: 1280 Diacritical in search string

by Owyn » Tue Nov 03, 2009 2:25 pm

> but I think it isn't a big deal, because ; is usually used as separator for multiple genres like Rock;Pop
Yeah. It is a pretty obscure use case. I was cleaning up after some RegExp appends of "; Cover" to Genre where Original Artist was known. In some cases Genre was blank before the append.

I had manually corrected several as I noticed them and wanted to see if I had missed any. The SELECT worked to find the one I missed and I can use it again if needed. Having it via Search would have allowed me to save the Search as an Auto-playlist. e.g. "Auto Fix ; at start of Genre".

No big deal, and Genres.GenreName LIKE ";%" would not find it anyway.

Not worth changing anything.
8)

Re: 1280 Diacritical in search string

by Ludek » Tue Nov 03, 2009 12:43 pm

Owyn,
you can search for ; via searchbar by typing ;

As you mean it doesn't work via search dialog -> Genre: ;
but I think it isn't a big deal, because ; is usually used as separator for multiple genres like Rock;Pop

Re: 1280 Diacritical in search string

by Owyn » Tue Nov 03, 2009 10:20 am

@Ludek
Got another case which I think is involved with Search escaping characters.

How would I search for Genre starting with ";", ie. the equivalent of

Code: Select all

select * from songs where substr(genre,1,1)=";"

Re: 1280 Diacritical in search string

by Owyn » Mon Nov 02, 2009 9:56 am

Ludek:
No problem, I understand exactly what is happening.

The original problem was raised when I got completely unexpected search results using 1280 (see first post).

The problem magically fixed itself with 1281. :o

Re: 1280 Diacritical in search string

by Ludek » Mon Nov 02, 2009 9:33 am

Owyn,
we have always searched via Search dialog (Artist->mel torme) as diacritical sensitive via LIKE on Artists.
i.e. not using SQLite's FTS3.

But Search bar "artist:mel torme" is diacritical insensitive MATCH on SongsText (using FTS3)

As I now japanese users uses search dialog, because they can search also middle of the words ('donna' finds 'maddona')
and the others uses Search bar "artist:mel torme", because it is diacritical insensitive.

We should probably somehow unify this, but I think we should leave it for 4.0, once we resolve issue
http://www.ventismedia.com/mantis/view.php?id=5565

I added the note to the issue (this way it is tracked)

Ludek.

Re: 1280 Diacritical in search string

by Owyn » Fri Oct 30, 2009 5:36 pm

Well. More testing in 1282.
Search bar "artist:mel torme" works and returns expected 128 tracks via diacritical insensitive MATCH on SongsText.
Search dialog (Artist->mel torme) is diacritical sensitive via LIKE on Artists.

I must have just tested search bar in 1281.

Re: 1280 Diacritical in search string

by Owyn » Fri Oct 30, 2009 5:10 pm

And, it's back with 1282. :cry: :roll:

Is anyone else seeing this?

It's a fairly important issue to me as I have a lot of artists/composers with diacriticals.

Re: 1280 Diacritical in search string

by Owyn » Fri Oct 30, 2009 8:26 am

Ummm. This is working now in 1281 for both Artist and Composer searches.
Nothing I can see in change log, but, ...

Re: 1280 Diacritical in search string

by Owyn » Thu Oct 29, 2009 5:18 pm

Well, I know what is happening.
The other 4/17 contained "Mel Torme" and "Mel Tormé", eg. "Mel Tormé; Artie Shaw And His Orchestra featuring Mel Torme and His Mel-Tones".

There appears to be no way to construct a diacritical insensitive search of Artist/Album Artist, ie. tracks = 128.

1280 Diacritical in search string

by Owyn » Thu Oct 29, 2009 1:40 pm

These searches give different results.

Search Bar:artist:Mel Torme(115 tracks)
Search Bar:artist:Mel Tormé(115 tracks)
Search->Artist:Mel Torme(17 tracks)
Search->Artist:Mel Tormé(115 tracks)

The 17 track case is not a subset of the 115 tracks. It includes 13 tracks for "Gerry Mulligan, Mel Torme, George Shearing" which are not included in the 115 plus 4 multi artist tracks.

Note: there is no diacritical in the additonal track artist tags.

Edit:
Search Bar:Mel Torme(130 tracks=115 + 13 + 2Composer contains Mel Torme)

Top