I'm fairly sure there are some texts where the "unaccent" thing is decidedly questionable.
2003-08-01 21341, 2003
codeFiend
hmm.
2003-08-01 21351, 2003
djce
Some scandinavian stuff, I think.
2003-08-01 21314, 2003
djce
But the whole idea of "unaccenting" sounds dodgy to me. It's inherently not locale-safe.
2003-08-01 21327, 2003
codeFiend
yeah.
2003-08-01 21330, 2003
codeFiend
definitely.
2003-08-01 21341, 2003
codeFiend
ok, well, now I'm wondering.
2003-08-01 21342, 2003
djce
But I'm glad the search works.
2003-08-01 21352, 2003
codeFiend
hmm.
2003-08-01 21354, 2003
codeFiend
gimme a minute here...
2003-08-01 21303, 2003
codeFiend
hmm... ok.
2003-08-01 21310, 2003
codeFiend
now I'm seeing a different problem with this, conceptually
2003-08-01 21329, 2003
codeFiend
I just added russian artist Aquarium, (in cyrillic) and put in a mod to merge the current listing into it... now, if an english-speaking person wants to find it, but they don't know how to spell it in cyrillic, are they going to be pretty much farked? perhaps a 'transliterated title' field should be added to the db?
2003-08-01 21356, 2003
codeFiend
or perhaps just adding an alias for the artist with the transliteration would be enough?
2003-08-01 21358, 2003
djce
It's an idea.
2003-08-01 21303, 2003
djce
aliases would work too.
2003-08-01 21305, 2003
codeFiend
hmm.
2003-08-01 21312, 2003
djce
In fact aliases are probably the better way to do it.
2003-08-01 21322, 2003
codeFiend
more generic, true.
2003-08-01 21323, 2003
codeFiend
hmm.
2003-08-01 21336, 2003
codeFiend
that works for artist names
2003-08-01 21338, 2003
djce thinks that codeFiend "hmm"s and ponders a lot.
2003-08-01 21342, 2003
djce
:-)
2003-08-01 21344, 2003
codeFiend shrugs
2003-08-01 21349, 2003
codeFiend is a thoughtful kinda person ;)
2003-08-01 21356, 2003
codeFiend
what about album names though? can't have aliases for those
2003-08-01 21305, 2003
djce
maybe we should do.
2003-08-01 21315, 2003
codeFiend
and some albums come out with transliterated titles in english-speaking countries, but some come out with translated titles
2003-08-01 21336, 2003
codeFiend
so, a person might search for 'Sestra Kaos', or 'Sister Chaos', or '������ ����'
2003-08-01 21351, 2003
codeFiend
which should all match one album
2003-08-01 21304, 2003
codeFiend
there's no good way to handle that right now.
2003-08-01 21310, 2003
djce
I think that aliases would fit that quite well.
2003-08-01 21328, 2003
djce
Now on a related note, I've always wanted to add an "alias type" field.
2003-08-01 21330, 2003
codeFiend
same for song names then?
2003-08-01 21341, 2003
codeFiend
yeah, alias type would come in useful if we had all these.
2003-08-01 21348, 2003
djce
possibly. Why not? Most tracks won't have any aliases, so no big deal.
2003-08-01 21306, 2003
codeFiend
alias types: group pseudonym | translation | transliteration
2003-08-01 21308, 2003
codeFiend
something like that ;)
2003-08-01 21310, 2003
djce
yes, where the alias types might include: spelling mistake,