Best way to handle multiple titles in database?

[Firestorm ZERO]

I'm currently planning a database for my site but I'm wondering what is the best way to implement multiple titles?

 

In a table I need to put in the Japanese title for a series. But then there is also the translated name, romanized name and then the localized name. And each one can have multiple names because for example the translated name can be interpreted differently, localized name for each region can be different (North America, Europe, etc) and so forth.

 

I want to put all possible titles so it can be easier for a user to search for a particular series name. But as you can see, it can have as many (or as little) names so I don't think I can separate each one into a column. So what would be the best approach for this?

[steelmanronald06]

two tables.  One table has these columns:

 

Table Name: japanese_titles

 

japanese_id

japanese_titleName

 

 

Table Name: translated_titles

 

trans_id

jap_id

translated_title

translation

 

Right, so trans_id is to keep each row unique. jap_id will match the japanese id from the first table.  Then the translated title is whatever you translated it into, and translation is what language it was translated into.  Then do a query to pull the japanese title id and name from the first table and then pull all the translated titles from the second table where jap_id equals the japanese_id of the first query!

[Firestorm ZERO]

Thanks for the tip