the first way is better, the second creates a wider table, and what happens when you start having more than just a few languages, the table grows wider still


From: Bruno B B Magalhães <[EMAIL PROTECTED]>
Subject: [PHP-DB] A language question
Date: Wed, 8 Dec 2004 11:31:22 -0200

Hi guys,

I am thinking about content translation...

Current I am using for example:

contentId | contentTitle | contentBody |  contentLanguage

So each row has its own language definition...

But would it be better using cols as language fields and retrieve only need cols...:

contentId | contentTitle_en_uk | contentBody_en_uk

The second option would be less space consuming?

Any others ideas?

Best Regards.
Bruno B B Magalhaes

PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to