View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000022||HTML & PERL||Bug Report - Interface||public||2004-12-02 18:54||2009-07-25 00:03|
|Target Version||Fixed in Version|
|Summary||0000022: Broken link in the mylist info box on any anime page with default lang not Romaji|
|Description||The link to the right page of your own mylist in the mylist info box on any anime page dun work if you don't use Romaji as default title language.|
I just deleted a file from "Ghost in the Shell - Stand Alone Complex". AniDB then took me to my mylist (as usual) to show me which files I have.
It took me to the letter "K" - which would be right, if I had GitS - SAC listed under the original title, "Koukaku Kidoutai STAND ALONE COMPLEX", which I don't. I then clicked the link for the letter "G" and there I was given what I looked for, with the "GitS SAC"-tree already expanded.
however, at least for language=kanji this can't be fixed easily.
don't expect to see a fix soon.
I think you need a "japanese sorting" column for this to work. Every japanese anime listing I've seen just uses the katakana/hiragana "alphabet" (A-I-U-E-O-KA-KI-KU-KE-KO and so on ...) with non-japanese names first transcribed into this and sorted alongside all the other names (thus, "DearS" is sorted among the other "DE" anime because its transcription starts with a "DE" and a small "I", "KURAU" is sorted alongside the other anime starting with "KU" and so on).
There are less than 80 different possible kana (a few over 80 with the small variants of A, I, U, E, O, YA, YU, YO and TSU). If you need them for sorting and nothing else (and can put up with decoding/encoding them for display and entry), you can just use a byte for each and use a simple non-charset-aware string sorting to get correct japanese sorting.
EDIT: fscking tracker can't fscking display the fscking japanese kana. Sorry for my French.
As katakana, hiragana, roman and kanji scripts are treated the same, and letters with dakuten or handakuten are grouped with those without, collation in japanese generally has 45 indices rather than 80 or more.
This isn't something exp could code himself though, he'd need some kind of bolt on code to handle japanese searching/sorting properly.
||This could be fixed for english though... 8)|
||Give me the target (programming) language and I'll write the collation routines. Hell, I'll write a perl-accessible C library for that if speed is an issue.|
I use SQL ORDER BY statements to sort the anime titles.
Non-Ascii titles are currently stored in their html-escaped form, which would make correct sorting near to impossible I'd guess :|
In the long run this could probably be fixed by completly moving to unicode UTF8 encoding in the db, in the perl cgis, the cron jobs, the irc bots and the apis.
I've looked into that about a year ago once and had quite some compatibility issues. But I'll probably try it again once we've had the time to update the base software (perl, libs, ...) on the server anidb is hosted on.
Until then I don't think there is any viable way to fix it.
||The point is that NO encoding won't help you in sorting the japanese titles, simply because the Japanese way is to sort by the pronunciation of the titles (as transcribed into kana, where necessary). You absolutely need a "sorting" column for that in addition to the "displayed title" column we already have. The former doesn't need to be in any particular encoding.|
||two years old and still unresolved? maybe instead of trying to make sorting work correctly for any default language just modify expand=xxxx so in wont show all the titles before this one on a single page and drop char=x part from the link?|
||hehe, we should probably look at this again, yeah }:o)|
||that seems fixed to me|
|2004-12-02 18:54||ninjamask||New Issue|
|2004-12-02 20:16||exp||Status||new => assigned|
|2004-12-02 20:16||exp||Assigned To||=> exp|
|2004-12-02 20:17||exp||Note Added: 0000020|
|2004-12-02 20:17||exp||Status||assigned => confirmed|
|2005-03-04 08:56||bbaab||Note Added: 0000290|
|2005-03-04 08:59||bbaab||Note Edited: 0000290|
|2005-03-04 22:43||Rar||Note Added: 0000291|
|2005-03-04 23:06||egg||Note Added: 0000292|
|2005-03-05 09:34||bbaab||Note Added: 0000293|
|2005-03-06 09:35||exp||Note Added: 0000294|
|2005-03-07 08:28||bbaab||Note Added: 0000296|
|2006-07-17 12:50||DerIdiot||Additional Information Updated|
|2007-05-08 05:44||epoximator||Relationship added||has duplicate 0000647|
|2007-05-08 05:45||epoximator||Summary||Broken link in the mylist info box on any anime page with fefault lang not Romaji => Broken link in the mylist info box on any anime page with default lang not Romaji|
|2007-05-08 06:23||Harkonnen||Note Added: 0001251|
|2007-12-29 08:26||exp||Relationship added||has duplicate 0000854|
|2007-12-29 08:28||exp||Assigned To||exp =>|
|2007-12-29 08:29||exp||Note Added: 0001574|
|2007-12-29 08:29||exp||Status||confirmed => acknowledged|
|2007-12-29 08:30||exp||Priority||normal => high|
|2008-02-10 22:02||ninjamask||Tag Attached: mylist|
|2009-07-25 00:03||DerIdiot||Note Added: 0002882|
|2009-07-25 00:03||DerIdiot||Status||acknowledged => resolved|
|2009-07-25 00:03||DerIdiot||Resolution||open => fixed|
|2009-07-25 00:03||DerIdiot||Assigned To||=> DerIdiot|