Episode names - limited to 100 letters? [DONE]

old granted and denied feature requests

Moderator: AniDB

Locked
Andemon
Posts: 117
Joined: Thu Oct 14, 2004 4:12 pm

Episode names - limited to 100 letters? [DONE]

Post by Andemon » Thu Mar 03, 2005 10:26 am

I'm planning to replace the current episode names for City Hunter 2 (...they are rather inaccurate...) with the ones from the english (r1) DVD box release.

I tried changing the name of the episode 17 from:
Japanese tradition woman`s desire!? Surpassed the international mokkori time (Part 1)
...to:
The Applicant Wants to be a Traditional Japanese Woman? Mokkori Can Overdrive National Boundaries (Part 1)

The problem? I found out that there's letter limit of 100 for the episode names. That episode has 106 letters. -_-;

Any chance that the limit could be set bit higher? That's the longest of the City Hunter 2 episode names, so raising the limit to 110 would suffice.

Either that, or someone tell me how I could reduce that to 100 letters... :|

User avatar
Elias
Posts: 242
Joined: Tue Feb 17, 2004 4:55 pm

Post by Elias » Thu Mar 03, 2005 2:58 pm

Part in parenthesis looks less important, so i would change it to:
The Applicant Wants to be a Traditional Japanese Woman? Mokkori Can Overdrive National Boundaries(1)
(exactly 100 characters)
And are you sure it's 100 characters limit? See title of 4th Genshinken episode:
The Sublimating Effect of the Dissimilation Brought on Through Makeup and Costume on Mental Obstacles
(101 characters)

Andemon
Posts: 117
Joined: Thu Oct 14, 2004 4:12 pm

Post by Andemon » Thu Mar 03, 2005 6:29 pm

I'm quite sure. Might be that the db already supports titles with more than 100 characters -- but the edit page definitely doesn't. It won't let me enter more than 100 characters into the 'Episode Title'-field.

I suppose I could use that shortened version. ...but shortening it makes me feel kinda like I'm entering inaccurate data into the db -- the DVD box titles do have those '(Part 1)' and '(Part 2)', after all... -_-;

I think I'll wait a bit and see if any of the mods care to comment about this. If not, I'll go ahead and use the shortened version.

egg
Posts: 769
Joined: Tue Nov 11, 2003 7:17 am

Post by egg » Thu Mar 03, 2005 7:35 pm

It appears to be a limitation of the creq page... The form specifies this field is supposed to have a max length of 100 characters. If you try to creq the Genshiken episode, copy and paste the title, the last character gets cut off. Now since obviously Genshiken has more than 100 characters, there is another place (a mod only page?) that does not have this limitation and the database can handle more. I would say that this is an obsolete maximum that should be updated to the new maximum.

wahaha
AniDB Staff
Posts: 1497
Joined: Sun Nov 17, 2002 3:33 pm

Post by wahaha » Fri Mar 04, 2005 12:38 pm

Odd enough, the regular input-field seems to take the exact 101-char title of that genshiken ep even with maxlength set to 100... I don't really have a clue why that works. ^^;

There's no special page that allows longer titles - Chii's !seteptitle doesn't seem to bother with the limit, though.
egg wrote:[...] the database can handle more. I would say that this is an obsolete maximum that should be updated to the new maximum.
definitely.

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Fri Mar 04, 2005 1:11 pm

all string fields in the database can be up to 2GB in size :P
the limitation for ep names is simply there bc anidb filenames will be generated using the full epname and some ppl will get problems if the filenames get too long.
so I would really recommend that you shorten that title somehow.

BYe!
EXP

egg
Posts: 769
Joined: Tue Nov 11, 2003 7:17 am

Post by egg » Fri Mar 04, 2005 4:41 pm

exp wrote:the limitation for ep names is simply there bc anidb filenames will be generated using the full epname and some ppl will get problems if the filenames get too long.
As a side question, why are the filenames created using the romaji anime title and the English episode title??? Shouldn't the default be all romaji or all English???

kidan
Posts: 319
Joined: Thu Feb 13, 2003 9:13 pm
Location: .DE

Post by kidan » Fri Mar 04, 2005 6:09 pm

Best thing would be a profile-option for customized links (which was requested some time ago). If this would be too heavy on the server some defaults to choose from would be an alternative, as those could be pregenerated.

Locked