I am working on a big multilingual web site project. It is a holiday booking site which will have countries, resorts and sub-resorts and also info pages for all.

All parts of the web site (adding countries, resorts hotels etc.) will be from the control panel.

I don't know how to plan the database structure to make it flexible for different languages.

Which one is better? To keep the language info in database? Or keep it in text based files?

Some content will not be directly translated to all languages so I need to create flexibility also this way.

I'll be glad if you share your opinion with me

Many thanks