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?