sinbad Posted January 20, 2007 Share Posted January 20, 2007 Hi,I want a table of all countries including the names of the countries in different languages.Please tell me which design is better1) countries (country_id, language_id, country_name) In design No 1, I will have three fields, but 200 records for each language, so that 1400 rocords for 7 languages2) countries (country_id, eng_name, fre_name, spa_name, Ger_name, etc )And in this case I will have no more than 200 rocords, but an extra field for each language.Please tell me what do you think.RegardsSinbad Link to comment https://forums.phpfreaks.com/topic/35011-a-question-of-table-design/ Share on other sites More sharing options...
ShogunWarrior Posted January 20, 2007 Share Posted January 20, 2007 The first one, otherwise if you needed to add a language then you would have to modify your table design which would not be good practice. Link to comment https://forums.phpfreaks.com/topic/35011-a-question-of-table-design/#findComment-165125 Share on other sites More sharing options...
sinbad Posted January 20, 2007 Author Share Posted January 20, 2007 Thanks ShogunWarrior, I had that feeling, and want to be sure Link to comment https://forums.phpfreaks.com/topic/35011-a-question-of-table-design/#findComment-165129 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.