It is currently 23 Apr 2024, 19:31




 Page 1 of 1 [ 6 posts ] 
Author Message
 Post subject: Multiple titles
PostPosted: 15 Oct 2011, 10:10 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1146 times
Hi folks!

For a long time, I have been using A.K.A.'s like this for title:

MAIN TITLE (Alternative Title 1/Alternative Title 2)

But we can do better than that. My problem was that PHP and MySQL were not initially very good at handling unicode and foreign language characters (Japanese, Russian, etc.). Things have changed since I took a look at it in 2006 and maybe it could be a good idea to revisit the titles now?

Here is a dev example for your perusal. Search works normally, even with non-roman characters.

Julien


Attachments:
Capture2.PNG
Capture2.PNG [ 39.36 KiB | Viewed 2323 times ]
Capture.PNG
Capture.PNG [ 140.14 KiB | Viewed 2323 times ]
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Multiple titles
PostPosted: 15 Oct 2011, 14:44 
Hardcore fan
Hardcore fan
User avatar

Joined: 23 Sep 2003, 18:14
Posts: 1391
Location: United States
Has thanked: 39 times
Been thanked: 21 times
Cool. That would allow definite improvements on anime discs, which are sometimes very confusing in regard to title.
_________________
MUSE decoder information and user guides
LD player connexion guide
Offline
 Profile  
 
 Post subject: Re: Multiple titles
PostPosted: 15 Oct 2011, 14:55 
True fan
True fan
User avatar

Joined: 04 Apr 2004, 18:11
Posts: 322
Location: Switzerland
Has thanked: 1 time
Been thanked: 8 times
Excellent !
Offline
 Profile  
 
 Post subject: Re: Multiple titles  Topic is solved
PostPosted: 27 Oct 2011, 00:02 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1146 times
I think you'll all like it!

Still need to fix the UTF-8 full-text search. It's working on my dev PC but not on the website...

Tonari no Totoro (1988) [98LXA-13]

Quote:
My Neighbor Totoro (1988) [98LXA-13]
となりのトトロ (cover)
Tonari no Totoro (original)


Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Multiple titles
PostPosted: 31 Oct 2011, 05:31 
Advanced fan
Advanced fan
User avatar

Joined: 20 Jul 2011, 04:51
Posts: 681
Location: United States
Has thanked: 0 time
Been thanked: 0 time
admin wrote:
I think you'll all like it!

Still need to fix the UTF-8 full-text search. It's working on my dev PC but not on the website...

Tonari no Totoro (1988) [98LXA-13]

Quote:
My Neighbor Totoro (1988) [98LXA-13]
となりのトトロ (cover)
Tonari no Totoro (original)


Julien

wouldn't "cover" be more original than "original" (the transliterated one)?
Offline
 Profile  
 
 Post subject: Re: Multiple titles
PostPosted: 31 Oct 2011, 17:06 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1146 times
naiaru wrote:
wouldn't "cover" be more original than "original" (the transliterated one)?


I'm trying to keep things flexible. Originally I was thinking that 2 titles could be enough, but trying a few exotic titles showed that at least 3 were needed.

"Cover" is more dedicated to non-Roman alphabets (Japanese, Chinese, Russian, Greek, etc.) that show on the cover in the local language (obi, etc.) while the main title is also available. If the local title is not a direct translation, then a romanized version (3rd title) could give additional information.

We also have the case of movies with completely different titles from one country to another. In that case the main title should be the "International" one, the "cover" title whatever was used for the local release (if different) and the "original" title the true movie title (if different from the 2 above).

I will review updates as they come. The idea is to improve the search hits while providing search engines with more relevant information to find the correct URLs. Maybe "original" could be renamed to something else.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 6 posts ] 


Who is online

Users browsing this forum: Google [Bot] and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: