View Single Post
  #191  
Old Apr 3, 2012, 08:02 PM
Kaleb.G's Avatar
Kaleb.G Kaleb.G is offline
VGMdb Staff
VGM Artist
 
Join Date: May 2007
Location: California, USA
Posts: 1,030
Default

There should be a more objective way of doing this. The actual "display title" should be determined based on user preference.

I suggest making an album title table with the following fields:
ALBUM_TITLE_ID
ALBUM_ID
OFFICIAL (bool flag)
LANGUAGE
TITLE

OFFICIAL is a boolean. It states if this title is listed on the album proper (or by publisher correction).

LANGUAGE can either be a code or a reference key to a master language table. It will specify either "Japanese" (Kanji/Hiragana/Katakana), "Romaji", "English", "German", "French", "Korean", etc. If the title contains a mix of languages, it could be assigned to a "Mixed" language, or we could just pick one that is most prominent.

[EDIT: This table has a many-to-one relationship to the album table. This means you can have multiple titles, and even multiple official titles.]

THEN, the user can choose what they want to see first as the "display title" based on their preferred order of combined LANGUAGE and OFFICAL statuses. For example, my own setting might be:
A. English (official)
B. English (unofficial)
C. Romaji (official)
D. Romaji (unofficial)
E. Japanese (official)

One of you might opt instead for something like:
A. English (official)
B. Romaji (official)
C. Romaji (unofficial)
D. English (unofficial)
E. Japanese (official)

This may create more overhead with DB calls, though we could possibly find ways to optimize this. Perhaps we only have two settings:

1. Preferred Language: "English", "Japanese", etc.
2. Title Priority: "Preferred Language", "Official Title"

Choosing "English" & "Preferred Language" would be like my first example for my own setting, whereas choosing "English" & "Official Title" would be like my second example that one of you might choose.
__________________
hi~

Last edited by Kaleb.G; Apr 5, 2012 at 09:33 PM.
Reply With Quote