LaserDisc Database
https://forum.lddb.com/

Multiple titles
https://forum.lddb.com/viewtopic.php?f=8&t=135		 Page 1 of 1
Author:  admin [ 15 Oct 2011, 10:10 ]
Post subject:  Multiple titles
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 2393 times ]
Capture.PNG
Capture.PNG [ 140.14 KiB | Viewed 2393 times ]
Author:  publius [ 15 Oct 2011, 14:44 ]
Post subject:  Re: Multiple titles
Cool. That would allow definite improvements on anime discs, which are sometimes very confusing in regard to title.
Author:  takou [ 15 Oct 2011, 14:55 ]
Post subject:  Re: Multiple titles
Excellent !
Author:  admin [ 27 Oct 2011, 00:02 ]
Post subject:  Re: Multiple titles  Topic is solved
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
Author:  naiaru [ 31 Oct 2011, 05:31 ]
Post subject:  Re: Multiple titles
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)?
Author:  admin [ 31 Oct 2011, 17:06 ]
Post subject:  Re: Multiple titles
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
Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/